Count Days between dates for open tasks only.

Allison Bishop

Hi,

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".

Paul Newcome

You would start it off with an IF/OR combo like so:

=IF(OR(Status@row = "3. Approved / Ready To Issue", Status@row = "4. Approved / Completed"), NETDAYS(.......))

Paul Newcome

You would start it off with an IF/OR combo like so:

=IF(OR(Status@row = "3. Approved / Ready To Issue", Status@row = "4. Approved / Completed"), NETDAYS(.......))

Allison Bishop

Thank you, I will try this. :)

Paul Newcome

Happy to help. 👍️

Allison Bishop

Worked perfectly, thank you!