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

[Guest]

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

 

[EdMac]

Hi Craig,

Have you tried the MAX function

=MAX(Range)

Works for dates as well as numbers

E

 

[Guest]

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

 

[Guest]

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

 

[Max]

No problem, Craig.
Glad you found it ..