Spreadsheet: 840270d1692617926-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
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete |  |  | 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
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2025-01-16 00:00:00 |  | Obsolete
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete |  |  | known:
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete |  |  | total entries |  | 39
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete |  |  | total released |  | 23
 |  |  |  | 2020-01-16 00:00:00 | 2021-09-16 00:00:00 | 2022-01-16 00:00:00 |  | Obsolete |  |  | overdue |  | 2
 |  |  |  | 2021-03-01 00:00:00 | 2022-12-01 00:00:00 | 2023-03-01 00:00:00 |  | Obsolete |  |  | not overdue |  | 21
 |  |  |  | 2021-05-12 00:00:00 | 2023-01-12 00:00:00 | 2025-05-12 00:00:00 |  | Obsolete
 |  |  |  | 2021-07-09 00:00:00 | 2023-04-09 00:00:00 | 2023-07-09 00:00:00 |  | Released, Revision started
 |  |  |  | 2022-12-01 00:00:00 | 2023-09-01 00:00:00 | 2023-08-01 00:00:00 |  | Released, Revision started
 |  |  |  | 2022-12-06 00:00:00 | 2023-09-06 00:00:00 | 2023-12-06 00:00:00 |  | Released, Revision started
 |  |  |  | 2022-03-03 00:00:00 | 2023-12-03 00:00:00 | 2024-03-03 00:00:00 |  | Released
 |  |  |  | 2022-03-04 00:00:00 | 2023-12-04 00:00:00 | 2024-03-04 00:00:00 |  | Released |  |  | tried options but incomplete formulas due to mistakes
 |  |  |  | 2022-04-22 00:00:00 | 2024-01-22 00:00:00 | 2024-04-22 00:00:00 |  | Released |  | not expired
 |  |  |  | 2022-05-09 00:00:00 | 2024-02-09 00:00:00 | 2024-05-09 00:00:00 |  | Released |  | expired
 |  |  |  | 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
 |  |  |  | 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
 |  |  |  | 2022-10-10 00:00:00 | 2024-07-10 00:00:00 | 2024-10-10 00:00:00 |  | Released |  | online given help | adapted formula limited range |  | adapted but unlimited range
 |  |  |  | 2023-01-24 00:00:00 | 2024-10-24 00:00:00 | 2025-01-24 00:00:00 |  | Released |  | expired
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released |  | not expired
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2023-02-27 00:00:00 | 2024-11-27 00:00:00 | 2025-02-27 00:00:00 |  | Released
 |  |  |  | 2023-03-28 00:00:00 | 2025-01-28 00:00:00 | 2025-03-28 00:00:00 |  | Released
 |  |  |  | 2023-06-07 00:00:00 | 2025-03-07 00:00:00 | 2025-06-07 00:00:00 |  | Released
 |  |  |  |  |  |  |  | Document Revision
 |  |  |  |  |  |  |  | Document Revision
 |  |  |  |  |  |  |  | Document Revision
 |  |  |  |  |  |  |  | Obsolete
 |  |  |  |  |  |  |  | Obsolete