return the greatest value in a range of cells

Jen · Oct 29, 2009

I have a list of dates and I want a function that will return the latest date
in the list. Is such a thing possible?

Mike · Oct 29, 2009

be sure the cells are formatted as dates, then use the formula "=MAX(range)".

Tushar Mehta · Oct 29, 2009

Check out Excel help for the MAX function.

I have a list of dates and I want a function that will return the latest date
in the list. Is such a thing possible?

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins

Jen · Oct 29, 2009

Great! Thanks for the swift reply.