Spreadsheet: 861301d1709211528-countif-function-for-dates-not-working-example-workbook
Sheet: Data

Name | Training 1 |  |  | Training 2 |  |  | Training 3 |  |  | Training 4 |  |  | Training 5 |  |  | Imagine 20 more 'Training' Columns here  Shortened for ease of view
Person A | Date Assigned | Date Completed | [NAME] | Date Assigned | Date Completed | [NAME] | Date Assigned | Date Completed | [NAME] | Date Assigned | Date Completed | [NAME] | Date Assigned | Date Completed | [NAME]
Person B | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00
Person C | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00
Person D | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00
Person E | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00
Person F | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00
Person G | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00
Person E | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00
Person F | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2025-01-02 00:00:00