Nov 18 2021 08:28 AM
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
Nov 18 2021 08:50 AM
Solution=IF(DateDue="","",DateDue)
Nov 18 2021 08:50 AM
Solution