Find most recent date

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

Guest

Is there a function that returns the most recent date from a list, or group,
of dates (the dates are in random order)?
 
Hi Andi

Try
=MAX(A1:A100)
Change range to suit where your dates are held
 
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 latest date from list and corresponding info 2
help with Blank Dates in a Range 1
Most recent receipt date for an item 3
Finding most recent date for each customer - XL 2007 2
VLOOKUP and Return Last 2 Values 5
formulas to count dates 2
Array to find relative position - is there a better way? 3
Lookup Closest Date 0

Back
Top