Spreadsheet: 840264d1692615282-how-to-to-count-all-dates-overdue-except-the-rows-with-a-obsolete-status-book3
Sheet: raw data

ID | Title | Rev. |  | Approved date | Review date | [NAME] date |  | status | Comments
 |  |  |  | 2022-12-01 00:00:00 | 2023-09-01 00:00:00 | 2023-12-01 00:00:00 |  | Released, Revision started
 |  |  |  |  |  |  |  | Document Revision
 |  |  |  | 2022-12-06 00:00:00 | 2023-09-06 00:00:00 | 2023-12-06 00:00:00 |  | Released, Revision started |  |  | im trying to get an overview of all the expiry dates that are released but overdue and released but not overdue. The formula needs to update itself when new lines are added
 |  |  |  |  |  |  |  | Document Revision
 |  |  |  | 2023-01-24 00:00:00 | 2024-10-24 00:00:00 | 2025-01-24 00:00:00 |  | Released
 |  |  |  | 2022-05-09 00:00:00 | 2024-02-09 00:00:00 | 2024-05-09 00:00:00 |  | Released
 |  |  |  | 2023-03-28 00:00:00 | 2025-01-28 00:00:00 | 2025-03-28 00:00:00 |  | Released
 |  |  |  | 2021-07-09 00:00:00 | 2023-04-09 00:00:00 | 2023-07-09 00:00:00 |  | Released, Revision started
 |  |  |  |  |  |  |  | Document Revision
 |  |  |  | 2021-07-13 00:00:00 | 2024-03-13 00:00:00 | 2024-07-13 00:00:00 |  | Released
 |  |  |  | 2021-07-13 00:00:00 | 2024-03-13 00:00:00 | 2024-07-13 00:00:00 |  | Released
 |  |  |  |  |  |  |  | Obsolete
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2021-05-12 00:00:00 | 2023-01-12 00:00:00 | 2023-05-12 00:00:00 |  | Obsolete
 |  |  |  | 2023-06-07 00:00:00 | 2025-03-07 00:00:00 | 2025-06-07 00:00:00 |  | Released
 |  |  |  |  |  |  |  | Obsolete
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2022-10-10 00:00:00 | 2024-07-10 00:00:00 | 2024-10-10 00:00:00 |  | Released
 |  |  |  | 2021-03-01 00:00:00 | 2022-12-01 00:00:00 | 2023-03-01 00:00:00 |  | Obsolete
 |  |  |  | 2022-03-04 00:00:00 | 2023-12-04 00:00:00 | 2024-03-04 00:00:00 |  | Released
 |  |  |  | 2022-03-03 00:00:00 | 2023-12-03 00:00:00 | 2024-03-03 00:00:00 |  | Released
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2022-04-22 00:00:00 | 2024-01-22 00:00:00 | 2024-04-22 00:00:00 |  | Released
 |  |  |  | 2022-06-14 00:00:00 | 2024-03-14 00:00:00 | 2024-06-14 00:00:00 |  | Released
 |  |  |  | 2022-06-14 00:00:00 | 2024-03-14 00:00:00 | 2024-06-14 00:00:00 |  | Released