Stop counting duration

Question

I have a date field that needs to count the number of days that have passed from the date entered AND also need to the field to stop counting when a status is changed to completed or completed previous plan - not sure how to set this up. 
fields are Date PoC Due (date field), PoC # of days past due (formula duration field Today()-[Date PoC Due]), Approval status (drop down field)------------------------------Lorrie------------------------------

Gary1 · Answer

You need a fourth field "Approval Complete" to track the date when the status was updated to complete/completed previous plan. Users can enter the date manually, or you can do it with a pipeline when the status changes.

Once that field is in place, you can use this formula:

If (
    IsNull([Approval Complete]),
    Today()-[Date POC Due],
    [Approval Complete]-[Date POC Due]
)

------------------------------
gary
------------------------------

Sign up

Login to the community