ExcelBanter - max value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - max value (https://www.excelbanter.com/excel-discussion-misc-queries/174289-max-value.html)

dchristo

max value

I need to find the max value of dates; if all cells are blank it returns the
value 01/00/1900; I don't want it to show that date, I want it to be blank

I tried: =IF(MAX(A1,A2,A3,A4)<"01/00/1900",MAX(A1,A2,A3,A4),"") and
=IF(MAX(A1,A2,A3,A4)<"01/00/1900",MAX(A1,A2,A3,A4),IF(MAX(A1,A2,A3,A4) =
"01/00/1900","")), but it still shows up.

ex.

a1 01/01/2008
a2 02/02/2008
a3 (is blank)
a4 01/31/2008

Mike H

max value

Maybe

=IF(MAX(A1:A4)=0,"",MAX(A1:A4))

Mike

"dchristo" wrote:

I need to find the max value of dates; if all cells are blank it returns the
value 01/00/1900; I don't want it to show that date, I want it to be blank

I tried: =IF(MAX(A1,A2,A3,A4)<"01/00/1900",MAX(A1,A2,A3,A4),"") and
=IF(MAX(A1,A2,A3,A4)<"01/00/1900",MAX(A1,A2,A3,A4),IF(MAX(A1,A2,A3,A4) =
"01/00/1900","")), but it still shows up.

ex.

a1 01/01/2008
a2 02/02/2008
a3 (is blank)
a4 01/31/2008

All times are GMT +1. The time now is 12:30 AM.