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)?