Find most recent date
 

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

Find most recent date
 

Hi Andi

Try
=MAX(A1:A100)
Change range to suit where your dates are held

--
Regards

Roger Govier


"Andi Sea" <Andi wrote in message
...
Is there a function that returns the most recent date from a list, or
group,
of dates (the dates are in random order)?

Find most recent date
 

use =MAX()


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550160