Formula to locate earliest and latest date

If you are getting a result of 01-00-1900, which is the same as zero, then the dates in your range are text values and not proper dates. If those dates are generated by a formula then you need to share the formula with us - why not attach a sample workbook? Details on how to do this are given in the yellow banner at the top of the screen.

Hope this helps.

Pete

I think I just did. Please let me know...

I can see that you edited the first post at 6:30pm, but I can't see any attachment.

Here's a longer description:

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

I will do that now

It should be there now. Sorry, I forgot to upload the first time.

You might be able to change your formula in I5 to this:

=IF(F5="","",RIGHT(F5,11)*1)

as the date is in a format that your regional settings will recognise as a date, although I'm not sure if the hyphens will be acceptable. A more general approach would be to change it like this:

=IF(F5="","",DATE(RIGHT(F5,5),MID(F5,FIND(" ",F5)+3,2),MID(F5,FIND("-",F5)+1,2)))

In either case, you need to apply the date format to that cell, then copy the formula down. Then MAX and MIN acting on these dates should return the latest and earliest dates as required.

Hope this helps.

Pete

I5=IF(F5<>"",RIGHT(F5,11)+0,"") copy down

This formula change text in number .(date is number).Formatting column I as date




M5=MIN(I5:I100)


M6=MAX(I5:I100)

I was able to make that work beautifully! Thank you very, very, much!

Not sure who that is aimed at, but glad to help.

You might like to know that you can show your appreciation and directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete