Spreadsheet: 809421d1671085234-backlog-aging-report-for-tasks-over-time-formula-task-schedule-example
Sheet: Sheet1

 |  | Task | Due Date | Completed Date
 |  | Task 1 | 2021-04-02 00:00:00 | 2021-09-19 00:00:00
 |  | Task 3 | 2021-05-14 00:00:00 | 2021-05-14 00:00:00 |  |  | 2021 |  |  |  |  |  |  |  |  |  |  |  | 2022
 |  | Task 20 | 2021-05-14 00:00:00 | 2021-05-14 00:00:00 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Task 4 | 2021-06-18 00:00:00 | 2021-06-18 00:00:00 |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
 |  | Task 2 | 2021-06-18 00:00:00 | 2021-07-15 00:00:00 |  | Due per Month
 |  | Task 62 | 2021-07-09 00:00:00 | 2021-07-09 00:00:00 |  | Due running total
 |  | Task 5 | 2021-07-22 00:00:00 | 2021-09-22 00:00:00
 |  | Task 21 | 2021-07-30 00:00:00 | 2021-07-30 00:00:00 |  | Total Complete
 |  | Task 28 | 2021-08-06 00:00:00 | 2021-08-06 00:00:00 |  | Completed running total
 |  | Task 43 | 2021-08-06 00:00:00 | 2021-08-06 00:00:00
 |  | Task 30 | 2021-08-13 00:00:00 | 2021-08-13 00:00:00 |  | Remaining per Month
 |  | Task 95 | 2021-08-13 00:00:00 | 2021-08-13 00:00:00 |  | Remaining running total
 |  | Task 15 | 2021-08-13 00:00:00 | 2021-10-13 00:00:00
 |  | Task 9 | 2021-08-27 00:00:00 | 2021-08-27 00:00:00 |  |  | Overdue at the end of the month
 |  | Task 41 | 2021-08-27 00:00:00 | 2021-08-27 00:00:00 |  | <30 Days overdue
 |  | Task 39 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 |  | 30-60 Days overdue
 |  | Task 40 | 2021-09-10 00:00:00 | 2021-09-10 00:00:00 |  | 60+ Days overdue
 |  | Task 10 | 2021-09-17 00:00:00 | 2021-12-17 00:00:00
 |  | Task 18 | 2021-09-24 00:00:00 | 2021-09-24 00:00:00 |  | Task 1 - in April 2021, this would be categorized as "<30 days overdue", in May this would become "30-60 days overdue", then June onwards 60+ days overdue
 |  | Task 22 | 2021-09-24 00:00:00 | 2021-09-24 00:00:00
 |  | Task 7 | 2021-09-24 00:00:00 | 2021-12-24 00:00:00
 |  | Task 11 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00
 |  | Task 37 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00
 |  | Task 63 | 2021-10-01 00:00:00 | 2021-10-01 00:00:00
 |  | Task 32 | 2021-10-01 00:00:00 | 2021-10-31 00:00:00
 |  | Task 13 | 2021-10-03 00:00:00 | 2021-12-15 00:00:00
 |  | Task 47 | 2021-10-08 00:00:00 | 2021-10-08 00:00:00
 |  | Task 69 | 2021-10-15 00:00:00 | 2021-10-15 00:00:00
 |  | Task 25 | 2021-10-22 00:00:00 | 2021-10-22 00:00:00
 |  | Task 38 | 2021-10-22 00:00:00 | 2021-10-22 00:00:00
 |  | Task 12 | 2021-10-29 00:00:00 | 2021-10-29 00:00:00
 |  | Task 26 | 2021-10-29 00:00:00 | 2021-10-29 00:00:00
 |  | Task 19 | 2021-11-05 00:00:00 | 2021-11-05 00:00:00
 |  | Task 45 | 2021-11-05 00:00:00 | 2021-11-09 00:00:00
 |  | Task 42 | 2021-11-12 00:00:00 | 2021-11-12 00:00:00
 |  | Task 57 | 2021-11-12 00:00:00 | 2021-11-12 00:00:00
 |  | Task 6 | 2021-11-19 00:00:00 | 2021-11-19 00:00:00
 |  | Task 46 | 2021-11-19 00:00:00 | 2021-11-19 00:00:00
 |  | Task 55 | 2021-11-26 00:00:00 | 2021-11-26 00:00:00
 |  | Task 66 | 2021-11-26 00:00:00 | 2021-11-26 00:00:00
 |  | Task 83 | 2021-11-26 00:00:00 | 2021-11-26 00:00:00
 |  | Task 44 | 2021-12-03 00:00:00 | 2021-12-05 00:00:00
 |  | Task 51 | 2021-12-09 00:00:00 | 2021-12-09 00:00:00
 |  | Task 67 | 2021-12-09 00:00:00 | 2021-12-09 00:00:00
 |  | Task 27 | 2021-12-17 00:00:00 | 2021-12-17 00:00:00
 |  | Task 29 | 2021-12-17 00:00:00 | 2021-12-17 00:00:00
 |  | Task 31 | 2022-01-14 00:00:00 | 2022-01-14 00:00:00
 |  | Task 36 | 2022-01-14 00:00:00 | 2022-01-14 00:00:00
 |  | Task 54 | 2022-01-14 00:00:00 | 2022-01-14 00:00:00
 |  | Task 68 | 2022-01-14 00:00:00 | 2022-01-14 00:00:00
 |  | Task 90 | 2022-01-14 00:00:00 | 2022-01-14 00:00:00
 |  | Task 48 | 2022-01-21 00:00:00 | 2022-01-21 00:00:00
 |  | Task 82 | 2022-01-21 00:00:00 | 2022-01-21 00:00:00
 |  | Task 52 | 2022-01-28 00:00:00 | 2022-01-28 00:00:00
 |  | Task 53 | 2022-01-28 00:00:00 | 2022-01-28 00:00:00
 |  | Task 56 | 2022-01-28 00:00:00 | 2022-01-28 00:00:00
 |  | Task 34 | 2022-01-28 00:00:00 | 2022-07-28 00:00:00
 |  | Task 8 | 2022-02-01 00:00:00 | 2022-02-01 00:00:00
 |  | Task 74 | 2022-02-03 00:00:00 | 2022-02-03 00:00:00
 |  | Task 35 | 2022-03-11 00:00:00 | 2022-03-11 00:00:00
 |  | Task 60 | 2022-03-11 00:00:00 | 2022-06-15 00:00:00
 |  | Task 59 | 2022-03-18 00:00:00 | 2022-03-18 00:00:00
 |  | Task 64 | 2022-03-18 00:00:00 | 2022-03-18 00:00:00
 |  | Task 76 | 2022-03-18 00:00:00 | 2022-03-18 00:00:00
 |  | Task 84 | 2022-03-18 00:00:00 | 2022-07-08 00:00:00
 |  | Task 61 | 2022-03-25 00:00:00 | 2022-07-25 00:00:00
 |  | Task 98 | 2022-03-25 00:00:00
 |  | Task 86 | 2022-04-01 00:00:00 | 2022-04-01 00:00:00
 |  | Task 58 | 2022-04-08 00:00:00 | 2022-04-08 00:00:00
 |  | Task 65 | 2022-04-15 00:00:00 | 2022-04-15 00:00:00
 |  | Task 78 | 2022-04-15 00:00:00 | 2022-04-15 00:00:00
 |  | Task 79 | 2022-04-15 00:00:00 | 2022-04-15 00:00:00
 |  | Task 88 | 2022-04-15 00:00:00 | 2022-04-15 00:00:00
 |  | Task 70 | 2022-04-15 00:00:00 | 2022-08-15 00:00:00
 |  | Task 71 | 2022-04-15 00:00:00 | 2022-08-15 00:00:00
 |  | Task 14 | 2022-04-22 00:00:00 | 2022-04-22 00:00:00
 |  | Task 89 | 2022-04-22 00:00:00 | 2022-04-22 00:00:00
 |  | Task 73 | 2022-04-22 00:00:00 | 2022-08-15 00:00:00
 |  | Task 100 | 2022-04-29 00:00:00 | 2021-12-09 00:00:00
 |  | Task 87 | 2022-04-29 00:00:00 | 2022-04-29 00:00:00
 |  | Task 94 | 2022-04-29 00:00:00 | 2022-04-29 00:00:00
 |  | Task 75 | 2022-05-13 00:00:00 | 2022-05-13 00:00:00
 |  | Task 91 | 2022-05-20 00:00:00 | 2022-05-20 00:00:00
 |  | Task 93 | 2022-05-20 00:00:00 | 2022-05-20 00:00:00
 |  | Task 97 | 2022-05-20 00:00:00 | 2022-05-20 00:00:00
 |  | Task 23 | 2022-06-03 00:00:00 | 2022-06-03 00:00:00
 |  | Task 80 | 2022-06-03 00:00:00 | 2022-06-03 00:00:00
 |  | Task 85 | 2022-06-03 00:00:00 | 2022-06-03 00:00:00
 |  | Task 92 | 2022-06-03 00:00:00 | 2022-06-03 00:00:00
 |  | Task 24 | 2022-06-13 00:00:00 | 2022-06-13 00:00:00
 |  | Task 72 | 2022-06-17 00:00:00 | 2022-08-15 00:00:00
 |  | Task 96 | 2022-06-24 00:00:00 | 2022-06-24 00:00:00
 |  | Task 99 | 2022-08-05 00:00:00 | 2022-08-05 00:00:00
 |  | Task 50 | 2022-12-17 00:00:00 | 2022-12-02 00:00:00
 |  | Task 16 | 2022-12-21 00:00:00 | 2022-12-23 00:00:00
 |  | Task 17 | 2022-12-21 00:00:00 | 2022-12-23 00:00:00