Hi,
I have a spreadsheet that has a load of tasks which shows "Due Dates" in Column H, "Current status" (Open, Overdue, Closed) in Column I and "Days Overdue" in column J.
I'm trying to find a way that I can get excel to update statues automatically and find a formula that will show how many days overdue tasks are while the task is still open but stop counting once it's set to closed.
For example:
Today being 12/06/20
Task 1 has a due date of 20/05/20 and was completed on 27/05/20. I'd like the column J to show that it was 7 days overdue but not continue to increase as the days increase.
Task 2 has a due date of 30/06/20 is currently open so Column J will show 0 until 30/06, where Column I will update to Overdue and Column J will increase by each day until it's set to closed where it will stop.
I hope that makes sense.
Thanks
Bookmarks