INVALID DATE TYPE

Question

Hi, I created a formula that derives a value-based date range but if the date field is blank, I receive an INVALID DATE TYPE comment in that specific row. I read a few comments online that says if I apply the IFERROR operator, it will remove this error, but it returns “Incorrect Argument Set”. Here’s a sample of my formula: This populates the Invalid data type error in the "testdate" where my Start Date column is blank: =IF(AND(OR(MONTH([Start Date]@row ) > 1, AND(MONTH([Start Date]@row ) = 1, DAY([Start Date]@row ) >= 10)), OR(MONTH([Start Date]@row ) < 2, AND(MONTH([Start Date]@row ) = 2, DAY([Start Date]@row ) <= 21))), "02 Feb ", "") This populates the “Incorrect Argument Set” error to the entire "testdate" column when I add the IFERROR operator to the script: =IFERROR(AND(OR(MONTH([Start Date]@row ) > 1, AND(MONTH([Start Date]@row ) = 1, DAY([Start Date]@row ) >= 10)), OR(MONTH([Start Date]@row ) < 2, AND(MONTH([Start Date]@row ) = 2, DAY([Start Date]@row ) <= 21))), "02 Feb ", "") Is this something you can assist me with?

Paul Newcome · Accepted Answer

The IFERROR gets wrapped around the entire original formula to include any closing parenthesis.

=IFERROR(original_formula, "")

So if your formula with an IFERROR would look like this:

=IFERROR(IF(……………), "")