Hi khuggart
You can use the Max function because dates are numbers
=MAX(H1:H100)
--
Regards Ron de Bruin
http://www.rondebruin.nl
"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