Find most recent date in a row of dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What formula would i need to use to find the most recent date in a row of
dates?
 
That depends on the row of dates.

If the dates will be greater than today, then you probablly need the MIN
date.
If the dates will be less than today, then you'll want the MAX date.
If they could be greater OR less tnan today and you want the date closest to
today, you probably need the MIN of the absolute values of the differences
between the dates and today.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Thank you both. This is a great forum for someone who has a lot to learn
about this powerful tool. Thank you for the time.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find most recent date in a row 4
Formula for Most Recent Date 1
accepting most recent date across columns 10
find & copy data from most recent entry 2
DATE ORDER 7
Formula help 1
Find the most recent date 4
How To Have A Cell Be Blank If... 2

Back
Top