Calculating Days Remaining and Past Due
I am trying to calculate the days remaining and days past due for each row, however, I want it to stop count if the status is closed.
As you can see we have a "Days Remaining/Days Past Due" column and those closed (the grayed out rows) still calculate a number which is what I do not want.
I tried doing it myself but although it counts the days past due, it's not counting the days remaining.
We have various statuses other than open and in-progress. We have a total of 9 different statuses. Just for context.
Please help. Thank you.
Help Article Resources
Check out the Formula Handbook template!