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.