I have sharepoint list to track projects:

  1. Date Started
  2. Date Completion
  3. Project Status (On-going, Completed, Hold, Cancelled)

I want to compute the number of days the project was completed.

If isblank[Completion Dated], today()-[date started] else [Date completion]- [Date Started]

How do I write this in the calculated formula?

1 Answer 1


Use formula like:

=IF(ISBLANK([Date Completion]), Today()-[Date Started], [Date Completion]-[Date Started]) 

Note: Calculated column will be evaluated only when list item is added/updated or calculated column formula is updated.

  • 1
    Thank you. Was hitting error using ISBLANK statement. What i did is try below and it worked: =IF([Actual Completion ]=0,DATEDIF([Start Date],TODAY(),"D"),[Actual Completion ]-[Start Date]) Commented Dec 9, 2022 at 8:39
  • Great, glad you found the solution! Commented Dec 9, 2022 at 9:07
  • Please accept it as an Answer if it helped you in any way & it will help others with similar question in future to find the correct answer easily. Commented Dec 9, 2022 at 9:08

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.