Spreadsheet: 843199d1695125781-hi-all-i-need-help-with-countifs-excel-test-for-candidate-in-progress-1-
Sheet: SWAPP Training Matrix

Name | Out of Date | Due in <90 Days | No Cell [NAME] | Complete | HSE induction | COSHH | Manual Handling | Working At Height | Injection Moulding | Forklift Test | Power Tools | Isolation and Lock-Off | Harness Fitting
[NAME] |  |  |  |  | 2025-12-12 00:00:00 | N/A | 2025-08-25 00:00:00 | 2026-02-27 00:00:00 | 2023-02-27 00:00:00 | 2026-02-26 00:00:00 | N/A | 2026-02-27 00:00:00 | 2026-02-27 00:00:00
[NAME] |  |  |  |  | 2023-10-27 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-07-30 00:00:00 | 2024-07-01 00:00:00 | 2024-07-01 00:00:00 | N/A |  | N/A
[NAME] |  |  |  |  | 2024-07-02 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-08-10 00:00:00 | 2024-08-10 00:00:00 | 2023-08-12 00:00:00 | N/A | N/A | N/A
[NAME] |  |  |  |  | 2026-01-19 00:00:00 | 2026-02-16 00:00:00 | 2025-08-25 00:00:00 | N/A | 2025-11-02 00:00:00 | 2025-11-02 00:00:00 | 2025-08-16 00:00:00 | 2026-02-08 00:00:00 | 2026-01-31 00:00:00
[NAME] |  |  |  |  | 2025-07-18 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-07-30 00:00:00 | 2025-07-19 00:00:00 | 2025-08-22 00:00:00 | 2025-07-18 00:00:00 |  | N/A
Eleanor |  |  |  |  | 2025-09-22 00:00:00 | N/A | 2025-08-25 00:00:00 | N/A | 2026-02-16 00:00:00 | 2024-03-09 00:00:00 | N/A | N/A | N/A
[NAME] |  |  |  |  | 2025-10-02 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-07-30 00:00:00 | 2025-12-01 00:00:00 | 2023-03-05 00:00:00 | 2025-12-01 00:00:00 | 2025-12-01 00:00:00 | 2025-12-01 00:00:00
[NAME] |  |  |  |  | 2026-01-19 00:00:00 | 2026-02-16 00:00:00 | 2025-08-25 00:00:00 | 2024-06-24 00:00:00 | 2025-11-02 00:00:00 | 2025-11-02 00:00:00 | 2025-08-16 00:00:00 | 2026-02-08 00:00:00 | 2026-01-31 00:00:00
[NAME] |  |  |  |  | 2025-05-16 00:00:00 | 2025-08-23 00:00:00 | 2025-08-25 00:00:00 | 2024-06-25 00:00:00 | 2026-02-27 00:00:00 | 2026-02-26 00:00:00 | 2025-08-23 00:00:00 | 2025-08-23 00:00:00 | 2025-08-23 00:00:00
[NAME] |  |  |  |  | 2024-11-24 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-10-30 00:00:00 | 2023-08-29 00:00:00 | 2022-11-25 00:00:00 | 2025-09-02 00:00:00 | 2025-09-03 00:00:00 | 2024-11-26 00:00:00
Jessica |  |  |  |  | 2025-05-13 00:00:00 | N/A | 2025-08-25 00:00:00 | 2025-09-14 00:00:00 | 2026-02-27 00:00:00 | 2022-12-05 00:00:00 | N/A | N/A | 2023-05-04 00:00:00
[NAME] |  |  |  |  | 2025-05-16 00:00:00 | N/A | 2025-08-25 00:00:00 | 2025-01-08 00:00:00 | 2026-02-20 00:00:00 | 2026-02-17 00:00:00 | N/A | 2025-09-01 00:00:00 | 2023-05-18 00:00:00
[NAME] |  |  |  |  | 2025-07-18 00:00:00 | N/A | 2025-08-25 00:00:00 | 2025-07-22 00:00:00 | 2025-08-23 00:00:00 |  | N/A | N/A | N/A
[NAME] |  |  |  |  | 2023-12-07 00:00:00 | 2022-08-23 00:00:00 | 2025-08-25 00:00:00 | N/A | 2026-02-20 00:00:00 | 2026-02-20 00:00:00 | N/A | N/A | N/A
[NAME] |  |  |  |  | 2023-09-02 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-09-08 00:00:00 | 2023-09-09 00:00:00 | 2023-09-07 00:00:00 | N/A |  | N/A
[NAME] |  |  |  |  | 2025-09-20 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-07-30 00:00:00 | 2026-01-24 00:00:00 | 2024-03-08 00:00:00 | 2025-11-02 00:00:00 | 2025-11-02 00:00:00 | N/A
[NAME] |  |  |  |  | 2025-09-21 00:00:00 | 2024-01-18 00:00:00 | 2025-08-25 00:00:00 | 2024-07-10 00:00:00 | 2026-02-04 00:00:00 | 2025-11-21 00:00:00 | 2024-07-29 00:00:00 | 2026-02-08 00:00:00 | 2025-11-21 00:00:00
Nicola |  |  |  |  | 2025-09-05 00:00:00 | N/A | 2025-08-25 00:00:00 | 2025-09-12 00:00:00 | 2025-09-12 00:00:00 | 2025-09-12 00:00:00 | N/A | 2025-09-12 00:00:00 | 2025-09-13 00:00:00
[NAME] |  |  |  |  | 2024-09-14 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-07-30 00:00:00 | 2024-11-29 00:00:00 | 2024-12-05 00:00:00 | N/A | N/A
[NAME] |  |  |  |  | 2025-03-30 00:00:00 | N/A | 2025-08-25 00:00:00 | 2025-12-04 00:00:00 | 2025-12-02 00:00:00 | N/A | N/A | N/A | N/A
Rebecca |  |  |  |  | 2024-06-28 00:00:00 | N/A | 2025-08-25 00:00:00 | 2024-06-29 00:00:00 | 2024-06-29 00:00:00 | 2024-06-30 00:00:00 | 2024-06-29 00:00:00 | 2024-06-29 00:00:00 | N/A
[NAME] |  |  |  |  | 2025-09-20 00:00:00 | 2024-11-19 00:00:00 | 2025-08-25 00:00:00 | 2024-06-25 00:00:00 | 2026-01-24 00:00:00 | 2024-03-04 00:00:00 | 2024-11-18 00:00:00 | 2024-12-02 00:00:00 | 2025-02-11 00:00:00
[NAME] |  |  |  |  | 2025-09-08 00:00:00 | 2025-12-18 00:00:00 | 2025-08-25 00:00:00 | 2024-08-16 00:00:00 | 2026-02-20 00:00:00 | 2026-02-20 00:00:00 | 2024-08-16 00:00:00 | 2025-12-19 00:00:00 | 2024-08-16 00:00:00
[NAME] |  |  |  |  | 2024-05-24 00:00:00 | N/A | 2025-08-25 00:00:00 | N/A | 2024-05-24 00:00:00 | 2024-05-24 00:00:00 | 2024-05-24 00:00:00 | 2024-06-10 00:00:00 | N/A
Samantha |  |  |  |  | 2024-08-09 00:00:00 | N/A | 2025-08-25 00:00:00 | 2024-08-10 00:00:00 | 2024-08-10 00:00:00 | 2024-08-10 00:00:00 | 2024-08-09 00:00:00 | 2023-08-10 00:00:00 | N/A
Smith |  |  |  |  |  | N/A | 2025-08-25 00:00:00 | 2025-11-29 00:00:00 | 2025-11-24 00:00:00 | N/A | N/A | N/A | N/A
[NAME] |  |  |  |  | 2025-09-08 00:00:00 | N/A | 2025-08-25 00:00:00 | 2023-07-30 00:00:00 | 2026-01-23 00:00:00 | 2026-01-23 00:00:00 | 2026-01-23 00:00:00 | 2026-01-23 00:00:00 | 2026-01-23 00:00:00
Tatenda |  |  |  |  | 2025-05-21 00:00:00 | N/A | 2025-08-25 00:00:00 | 2024-06-24 00:00:00 | 2026-02-13 00:00:00 | 2023-07-12 00:00:00 | N/A | N/A | 2026-02-14 00:00:00
[NAME] |  |  |  |  | 28/06/2028 | 30/06/28 | 30/06/28 | 17/07/29 | N/A | 17/07/29 | N/A | N/A | N/A