Time Taken calculation. Start date, Completion Date & No Completion Date

[lennox25]

I need work out how many of my tasks which all have a start date, have no completion date and how long each one has been outstanding (in days).

Can anyone help with this calculation?

[SamWiseOwl · Accepted solution]

Hi @lennox25 

Create a new calculated column in the table:

Days Outstanding =

IF(

    ISBLANK([EndDate])

    ,DATEDIFF([StartDate],TODAY(),DAY)

    ,BLANK()

)

Use the ID of your items with this in a visual and filter to only items with a BLANK completion date:

Hope this helps! If it does please mark as a solution for others to find.

[lennox25]

Perfect - Thank you!