Display latest date in a column
 

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

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

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

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

"Roger Govier" wrote:

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

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