• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to help to get earliest date from range


New Member
Dear Sir,

Kindly need help,

I have multiple events in columns B and I am looking for the output in new sheet which event was 1st event. Example, the Row # 17 should show first. in this way I have around 4000 records.

Thanking you in advance, I prefer the formula without macro.



Well-Known Member
1. Your dates are shown as text. You need to convert them to numerical Date values. Then apply the Min function to find the earliest date.