Hello, I am currently working on a project monitoring board and I wanna ask as to what formula I can use to know the days overdue and days in advanced between date completed and due date. Also, I wanna what formula to use to determine conditions based on the number of days from the previous formula.
The scale are below:
5: 100% are completed 2 weeks advanced
4: 100% are completed 1 week advanced
3: 100% are completed within deadline