Need help to find a date (latest date) from a column

C

CraigNowell

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
 
E

EdMac

Hi Craig,

Have you tried the MAX function

=MAX(Range)

Works for dates as well as numbers

E
 
C

CraigNowell

Thank you for your suggestion EdMac - I appreciate your response. I did
actually discover this function shortly after posting my query, but many
thanks for responding

Regards,

Craig Nowell, UK
 
C

CraigNowell

Thank you for your suggestion Max - I appreciate your response. I did
actually discover this function shortly after posting my query, but many
thanks for responding

Regards,

Craig Nowell, UK
 
Top