Count Days between dates for open tasks only.


I have a formula that counts the number of NETDAYs a task has been "aging". However, I am looking for a formula that will only count the days if the task has NOT been completed.

In basic language, I need the formula that says count NETDAYS if STATUS at row is "3. Approved / Ready To Issue", or "4. Approved / Completed".

Best Answer