max value

[dchristo]

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]

Maybe

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

Mike