Have a look in the help index for MAX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dave" wrote in message
...
I have a spreadsheet with a list of dates, All I need is some kind of
formula to calculate the last date entered in column E at the end. An
example is below:

A B C D E
01/11/07 03/11/07 03/11/07
02/11/07 03/11/07 04/11/07 04/11/07
- -
05/11/07 05/11/07