SOLVED

Avoid Error if Date is blank

Steel 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 (Steel Contributor)
Solution

@Tony2021 

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

perfect! thanks!
1 best response

Accepted Solutions
best response confirmed by Tony2021 (Steel Contributor)
Solution

@Tony2021 

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

View solution in original post