I am trying to calculate difference (in days) between two dates in SharePoint 2013 using the formula below:


This works fine. However, the completed date remains empty until the action is completed. This creates a !Num error when I run the calculation. How do I integrate this with ISBLANK formula to remove the !Num error.

1 Answer 1


It seems I have found the solution to my own question. I nested two IF statements as below


It worked fine in Excel. I will try to use it in SharePoint as see if it works there too!

  • It works fine in SharePoint!! I hope this can help others
    – Jamal
    Nov 24, 2016 at 8:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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