SOLVED

Avoid Error if Date is blank

%3CLINGO-SUB%20id%3D%22lingo-sub-2981196%22%20slang%3D%22en-US%22%3EAvoid%20Error%20if%20Date%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981196%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20formula%3A%3C%2FP%3E%3CP%3E%3DDateDue%26nbsp%3B%3C%2FP%3E%3CP%3EDateDue%20is%20a%20named%20range%3C%2FP%3E%3CP%3EIf%20there%20is%20no%20date%20then%20it%20returns%20a%201%2F0%2F1900%3C%2FP%3E%3CP%3EHow%20can%20I%20avoid%20this%20and%20just%20return%20null%20if%20the%20date%20is%20null%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thought%20iserror%20but%20I%20dont%20think%20that%20works%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2981196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2981319%22%20slang%3D%22en-US%22%3ERe%3A%20Avoid%20Error%20if%20Date%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2981319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1029845%22%20target%3D%22_blank%22%3E%40Tony2021%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(DateDue%3D%22%22%2C%22%22%2CDateDue)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

Hello,

 

I have a formula:

=DateDue 

DateDue is a named range

If there is no date then it returns a 1/0/1900

How can I avoid this and just return null if the date is null?  

 

I thought iserror but I dont think that works

 

thank you

2 Replies
best response confirmed by Tony2021 (Frequent Contributor)
Solution

@Tony2021 

=IF(DateDue="","",DateDue)

perfect! thanks!