Use MAX(A1:A100) where A1:A100 contain your list of dates and that will give
you the latest date.
--
Regards
Roger Govier
"khuggart" wrote in message
...
I need to calculate a date based on the latest invoice date which is listed
in a column. I've tried nested IF statements, but cannot nest enough IF
statements. Any suggestions how I can determine the latest date in a
column?
Thanks in advance
|