Forum Discussion

Learning-Excel's avatar
Learning-Excel
Copper Contributor
Apr 07, 2022

=if

=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?

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 07, 2022
    =IF(D56=0,"LOST",DATEDIF(B56,D56,"D")) or =IF(D56=DATE(1900,1,1),"LOST",DATEDIF(B56,D56,"D"))

Resources