As dates are numbers,
try in say, B1: =MAX(A:A)
where dates are in col A

Format B1 as date
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CraigNowell" wrote:

I would very much appreciate it if someone could advise me which formula I
need to use to return the HIGHEST date from a range of dates assembled in a
column. I have tried to type in a load of different help questions in Excel,
and nothing helps. The date is shown in this format: 30/06/2006 (UK date
format), and the range could be between 01/01/2006 - 30/08/2006. What I want
to do is return the LAST date from that range into the cell I am detailing
the formula.

Many thanks,

Craig Nowell