FV_64
New Member
- Joined
- Jun 22, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hello all,
I am working on a task tracking spreadsheet for our team.
I want to come up with a formula to calculate how many days overdue a task is (column J), while taking in consideration that: the original due date (column G), that sometimes we will need to update that due date (column H), and once the task is completed the completion date is entered in column K.
Attached is a screenshot of the template (mock data). Would appreciate any help on this.
I am working on a task tracking spreadsheet for our team.
I want to come up with a formula to calculate how many days overdue a task is (column J), while taking in consideration that: the original due date (column G), that sometimes we will need to update that due date (column H), and once the task is completed the completion date is entered in column K.
Attached is a screenshot of the template (mock data). Would appreciate any help on this.