Using Max Return 1/1/1900

Question

Hi All

I have this formula =MAX(B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2,) which returns the latest date but if it is blank is returning 1/0/1900 (which is not a welcome result)

So I tried this (which usually does the trick) =IF(MAX(B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2)="","",MAX(B2,C2,D2,E2,F2,G2,H2,I2,J2,K2,L2,M2,N2)) but still doesn't work

what could be a solution?

Thank you

Answer 1

MAX never returns "", it always returns a number. Try

=IF(COUNT(B2:N2)=0, "", MAX(B2:N2))

Answer 2

Thank you HansV. That works perfectly