=if

[Learning-Excel]

=IF(D56="1/1/1900","LOST",DATEDIF(B56,D56,"D"))

I wrote this if statement. But when the date 1/1/1900 does come up I get #NUM!

All ot

¿Does anyone know how I can fix this?

[#2]

=IF(D56=0,"LOST",DATEDIF(B56,D56,"D")) or =IF(D56=DATE(1900,1,1),"LOST",DATEDIF(B56,D56,"D"))