I am using Microsoft sharepoint.

I have 3 fields: - Date Created - Date Closed - Duration

I am trying to work out how to get the duration column to populate whilst the date created field has been populated but date closed has not.

I currently have entered:

=DATEDIF([Created Date],[Completed Date],"d")

This helps only when I enter a completed date, if I don't it comes up with a status of #NUM.

Does anyone know how I can have duration field to also show number of days issue was created whilst the date completed field has not been populated.

Thank You

1 Answer 1


What do you want displayed when there is missing data? "n/a"? If you want it to display the number of days since created, then Calculated Columns cannot do that. They are calculated when they are created and not updated until the list item is updated. They are not updated on each view.

=IF( ISBLANK( [Completed Date] ), "n/a", DATEDIF([Created Date],[Completed Date],"d") )
  • Thanks Mike, that is helpful. I will look further to see if I can set it up for all views. Appreciate your help.
    – fazsnatch
    Oct 23, 2018 at 14:58

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.