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