Thank you. I knew there was an easy way.

"Ron de Bruin" wrote:

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