1

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"))
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

  • 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 Aug 15 '17 at 8:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.