Wrapping ISDATE calculated column with IFERROR (Sharepoint Online)

Question

Currently, have a calculated column that calculates the difference in days between 2 date columns.

=DATEDIF([Issue Date],[Due Date],"d")

When there is no value entered or an incorrect value entered, it displays as "#Name?"

Tried wrapping IFERROR around it but not sure on the syntax.

Current syntax:

=DATEDIF(ISERROR(([Issue Date],[Due Date],"d")),"",([Issue Date],[Due Date],"d"))

SharePointer · Accepted Answer · 2017-08-14 19:00:25Z

3

Try this:

=IF(ISERROR(DATEDIF([Start Date],[Due Date],"d")),"",DATEDIF([Start Date],[Due Date],"d"))

You will need to add IF condition to evaluate ISERROR return value which True or False. More details here

answered Aug 14, 2017 at 19:00

SharePointer

3,0461 gold badge14 silver badges28 bronze badges

Works perfectly, much obliged. So for something similar using a different error condition, would you always wrap it in an IF first off, before inserting your IS condition?
– cod3r_jim
Commented Aug 15, 2017 at 8:42

Add a comment |

1 Answer 1