Spreadsheet: 867916d1714664445-if-dates-less-than-x-date-return-result-move-or-not-based-on-dates-05022024-aligw
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IGNORE |  | Expected Results
 | ID |  |  |  |  |  |  |  | 1A TMD |  |  | 2A TMD |  |  |  | 2B TMD |  |  | 3C TMD |  |  | 3D TMD |  |  | 3E TMD |  | AppStat/Phase/Step | [NAME] | Architect | CATO | Current Phase | Current Step | DCC Type | Dev/NonDev | Epic Owner | Exception Ind | [NAME] | IAMS | IAMS Est Amt | Jeop Color | Jeop Desc | [NAME] to Grn | [NAME] to Ylw | Jeop Impact | [NAME] to Grn | [NAME] to Ylw | Last Out | MDE | Mig Assess | Mig Assess Assign | Mig Assess Contact | [NAME] | Next Due Date | Ph1Mgr Assigned | Ph1Mgr Date | PMATT | Program | Program Mgr | PSD Contact | PSD Req Date | SM [NAME] | Target DC | TMD |  | [NAME] |  | AliGW
 | 283 |  |  |  |  |  |  |  | 2022-04-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-03-31 00:00:00 |  | Move
 | 798 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-30 00:00:00 |  |  |  |  |  | 2024-05-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-30 00:00:00 |  | Move
 | 4021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-13 00:00:00 |  |  | 2025-07-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-13 00:00:00
 | 4615 |  |  |  |  |  |  |  | 2022-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-30 00:00:00 |  | Move
 | 4722 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-20 00:00:00 |  |  | 2025-07-13 00:00:00 |  |  | 2025-07-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-13 00:00:00
 | 4820 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00
 | 5744 |  |  |  |  |  |  |  | 2024-11-07 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-11-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-11-07 00:00:00 |  | Move
 | 5984 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00
 | 7006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-05-31 00:00:00 |  | Move
 | 7155 |  |  |  |  |  |  |  | 2021-11-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2023-05-30 00:00:00 |  |  |  |  |  | 2024-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00 |  | Move
 | 7310 |  |  |  |  |  |  |  | 2022-10-20 00:00:00 |  |  | 2024-04-30 00:00:00 |  |  |  | 2022-06-30 00:00:00 |  |  | 2025-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-30 00:00:00
 | 7547 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-23 00:00:00
 | 8033 |  |  |  |  |  |  |  | 2022-10-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  | 2024-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-30 00:00:00 |  | Move
 | 8306 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-13 00:00:00 |  |  | 2025-07-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-13 00:00:00
 | 8651 |  |  |  |  |  |  |  | 2022-08-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-11-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-11-29 00:00:00 |  | Move
 | 8682 |  |  |  |  |  |  |  | 2024-12-01 00:00:00 |  |  | 2024-04-30 00:00:00 |  |  |  | 2022-06-30 00:00:00 |  |  | 2025-12-31 00:00:00 |  |  | 2025-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-30 00:00:00
 | 8690 |  |  |  |  |  |  |  | 2023-08-31 00:00:00 |  |  |  |  |  |  |  |  |  | 2025-12-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-30 00:00:00
 | 9248 |  |  |  |  |  |  |  | 2022-10-20 00:00:00 |  |  | 2022-06-30 00:00:00 |  |  |  | 2022-06-30 00:00:00 |  |  | 2024-09-30 00:00:00 |  |  |  |  |  | 2024-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-30 00:00:00 |  | Move
 | 9367 |  |  |  |  |  |  |  | 2022-06-30 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-12-13 00:00:00 |  |  |  |  |  | 2024-12-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-12-13 00:00:00 |  | Move
 | 9572 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00
 | 9573 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-07-10 00:00:00
 | 9899 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-29 00:00:00 |  |  |  |  |  | 2025-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-06-30 00:00:00
 | 10097 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-31 00:00:00
 | 10727 |  |  |  |  |  |  |  | 2022-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-30 00:00:00
 | 12585 |  |  |  |  |  |  |  | 2024-08-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-25 00:00:00 |  | Move
 | 12765 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-06-30 00:00:00 |  |  |  |  |  | 2025-07-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-06-30 00:00:00
 | 12884 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-04-30 00:00:00
 | 13287 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 |  |  |  |  |  | 2024-07-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 |  | Move
 | 13980 |  |  |  |  |  |  |  | 2024-10-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-10-28 00:00:00 |  | Move
 | 14133 |  |  |  |  |  |  |  | 2024-10-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-10-31 00:00:00 |  | Move
 | 14209 |  |  |  |  |  |  |  | 2022-08-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-01 00:00:00 |  | Move
 | 14311 |  |  |  |  |  |  |  | 2021-06-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-07-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-08 00:00:00 |  | Move
 | 14430 |  |  |  |  |  |  |  | 2022-07-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-06-28 00:00:00 |  |  |  |  |  | 2024-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-28 00:00:00 |  | Move
 | 14432 |  |  |  |  |  |  |  | 2022-03-07 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-06-28 00:00:00 |  |  |  |  |  | 2024-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-28 00:00:00 |  | Move
 | 14560 |  |  |  |  |  |  |  | 2022-02-28 00:00:00 |  |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00 |  |  |  |  |  | 2024-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-01 00:00:00 |  | Move
 | 14644 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-30 00:00:00 |  | Move
 | 14855 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-23 00:00:00
 | 14856 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-02-23 00:00:00
 | 14969 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-31 00:00:00 |  | Move
 | 17456 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-30 00:00:00 |  | Move
 | 17488 |  |  |  |  |  |  |  | 2022-09-12 00:00:00 |  |  | 2024-04-30 00:00:00 |  |  |  | 2022-04-08 00:00:00 |  |  | 2025-12-31 00:00:00 |  |  |  |  |  | 2026-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-30 00:00:00
 | 17583 |  |  |  |  |  |  |  | 2022-12-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-23 00:00:00 |  | Move
 | 17689 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-06-01 00:00:00 |  |  |  |  |  | 2026-06-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-06-01 00:00:00
 | 17720 |  |  |  |  |  |  |  |  |  |  | 2022-08-31 00:00:00 |  |  |  | 2022-08-31 00:00:00 |  |  | 2024-08-16 00:00:00 |  |  | 2024-12-31 00:00:00 |  |  | 2024-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-08-16 00:00:00 |  | Move
 | 17762 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-23 00:00:00 |  | Move
 | 17786 |  |  |  |  |  |  |  |  |  |  | 2024-04-30 00:00:00 |  |  |  | 2022-05-31 00:00:00 |  |  | 2025-12-30 00:00:00 |  |  |  |  |  | 2026-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2025-12-31 00:00:00