#Invalid Data Type

Question

Hi There

I am using the below formula to check a box if a date is one day greater than today. The formula works fine except if the date field is blank, then it is showing up #Invalid Data Type.

How can the results show up as blank instead of #Invalid Data Type if there is no date referenced yet?

=IF(NETDAYS([Date to archive record]@row, TODAY()) > 1, 1, 0)

Any help is appreciated. Thanks!

Anjanesh Vaidya · Accepted Answer

Hi Kate123,

You can use IFERROR as below to achieve what you mentioned.

=IFERROR(IF(NETDAYS([Date to archive record]@row, TODAY()) > 1, 1, 0)," ")

I hope it will work.

Thank you

Anjanesh Vaidya