Display latest date in a column

khuggart · Jul 13, 2005

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

Ron de Bruin · Jul 13, 2005

Hi khuggart

You can use the Max function because dates are numbers
=MAX(H1:H100)

Roger Govier · Jul 13, 2005

Use MAX(A1:A100) where A1:A100 contain your list of dates and that will give
you the latest date.

khuggart · Jul 13, 2005

Thank you ... I knew there was an easy way ...

Roger Govier said:
Use MAX(A1:A100) where A1:A100 contain your list of dates and that will give
you the latest date.

khuggart · Jul 13, 2005

Thank you. I knew there was an easy way.

Ron de Bruin said:
Hi khuggart

You can use the Max function because dates are numbers
=MAX(H1:H100)