Spreadsheet: 838940d1691526511-formula-to-count-how-many-times-dates-change-in-a-list-countdatechanges
Sheet: Data

Project | Status | Investment Type | Portfolio | Project Manager | Start Date | Completion Date | Due Date (Project) | Calculated Completion Date | Initial Target Date |  | Duration (Months) | Total Slip (Months) | # of times slipped | # [NAME] < 1 week | Jul '22 | Aug '22 | Sep '22 | Oct '22 | Nov '22 | Dec '22 | Jan '23 | Feb '23 | Mar '23 | Apr '23 | May '23 | Jun '23 | Jul '23 | Aug '23
 |  |  |  |  |  |  |  |  |  | PM Dept |  |  |  |  | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date | Target Date
Project 1 | In Progress | Implementation | Business Operations |  | 2023-01-01 00:00:00 |  | 2023-08-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 2023-08-25 00:00:00 |  |  | #[NAME]! | #[NAME]! | #[NAME]! | True | True | True | True | True | True | True | True | False
Project 2 | In Progress | Implementation | Business Operations |  | 2023-01-01 00:00:00 |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00
Project 3 | In Progress | Discovery | Investment Product |  | 2022-08-01 00:00:00 |  | 2023-10-01 00:00:00 |  |  |  |  |  |  |  | 2022-12-31 00:00:00 | 2022-12-31 00:00:00 | 2022-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-04-28 00:00:00 | 2023-04-28 00:00:00 | 2023-04-28 00:00:00 | 2023-04-28 00:00:00 | 2023-04-28 00:00:00 | 2023-05-26 00:00:00 | 2023-05-26 00:00:00 | 2023-06-09 00:00:00 | 2023-10-01 00:00:00 | 2023-10-01 00:00:00
Project 4 | In Progress | Implementation | Information Security |  | 2022-01-10 00:00:00 |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 2023-12-29 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00
Project 5 | In Progress | Implementation | Split |  | 2023-03-27 00:00:00 |  | 2023-09-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | 2023-05-17 00:00:00 | 2023-05-17 00:00:00 | 2023-05-17 00:00:00 | 2023-06-30 00:00:00 | 2023-09-20 00:00:00 | 2023-09-20 00:00:00 | 2023-09-20 00:00:00
Project 6 | In Progress | Implementation | Business Operations |  | 2022-03-01 00:00:00 |  | 2023-08-31 00:00:00 |  |  |  |  |  |  |  | 2022-11-04 00:00:00 | 2022-11-04 00:00:00 | 2022-11-04 00:00:00 | 2022-11-04 00:00:00 | 2023-01-31 00:00:00 | 2023-01-31 00:00:00 | 2023-01-31 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00
Project 7 | In Progress | Implementation | Critical Infrastructure |  | 2022-09-01 00:00:00 |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00
Project 8 | In Progress | Implementation | Investment Product |  | 2023-04-05 00:00:00 |  | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00
Project 9 | In Progress | Implementation | Services Management |  | 2019-09-04 00:00:00 |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  | 2022-07-15 00:00:00 | 2022-09-02 00:00:00 | 2022-09-02 00:00:00 | 2022-12-02 00:00:00 | 2022-12-02 00:00:00 | 2023-03-03 00:00:00 | 2023-03-03 00:00:00 | 2023-03-03 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00
Project 10 | In Progress | Discovery | Business Operations |  | 2023-07-10 00:00:00 |  | 2023-07-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-28 00:00:00 | 2023-07-28 00:00:00
Project 11 | In Progress | Implementation | Community Growth |  | 2023-02-01 00:00:00 |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00
Project 12 | In Progress | Implementation | Critical Infrastructure |  | 2022-01-01 00:00:00 |  | 2023-09-29 00:00:00 |  |  |  |  |  |  |  | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2022-10-31 00:00:00 | 2023-03-31 00:00:00 | 2023-03-31 00:00:00 | 2023-03-31 00:00:00 | 2023-03-31 00:00:00 | 2023-03-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-09-29 00:00:00
Project 13 | In Progress | Implementation | Information Security |  | 2022-01-10 00:00:00 |  | 2023-09-29 00:00:00 |  |  |  |  |  |  |  |  | 2022-11-29 00:00:00 | 2022-11-29 00:00:00 | 2022-12-23 00:00:00 | 2022-12-09 00:00:00 | 2022-12-23 00:00:00 | 2022-12-23 00:00:00 | 2022-12-23 00:00:00 | 2023-09-29 00:00:00 | 2023-09-29 00:00:00 | 2023-09-29 00:00:00 | 2023-09-29 00:00:00 | 2023-09-29 00:00:00 | 2023-09-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 | True | True | True | True | True | True | True | True | False