Spreadsheet: 820641d1678209628-filter-not-matching-records-to-dates-230307-filter-not-matching
Sheet: Calendar

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  | Input |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  | Select Month | 2023-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00
 |  |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  |  |  | 2022-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-05-01 00:00:00
 | D | Date | Title | Custodian | Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00
 |  | 2023-03-01 00:00:00 | JOB 1 | EMPLOYEE 1 | First test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-01 00:00:00
 |  | 2023-03-03 00:00:00 | JOB 1 | EMPLOYEE 1 | Second Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-08-01 00:00:00
 |  | 2023-03-03 00:00:00 | JOB 2 | EMPLOYEE 2 | First test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-09-01 00:00:00
 |  | 2023-03-06 00:00:00 | JOB3 | EMPLOYEE 3 | Third Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-10-01 00:00:00
 |  | 2023-03-08 00:00:00 | JOB4 | EMPLOYEE 4 | Fourth Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ` |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026-06-01 00:00:00
 |  |  |  |  |  |  |  | Should be this: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026-09-01 00:00:00
 |  |  |  |  |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  |  |  | 2026-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2026-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | JOB 1 |  |  |  | JOB 1 |  |  |  |  |  |  |  | 2026-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE 1 |  |  |  | EMPLOYEE 1
 |  |  |  |  |  |  |  |  |  |  |  |  | First test |  |  |  | Second Test
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOB 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First test
 |  |  |  |  |  |  |  |  | JOB3 |  |  |  | JOB4
 |  |  |  |  |  |  |  |  | EMPLOYEE 3 |  |  |  | EMPLOYEE 4
 |  |  |  |  |  |  |  |  | Third Test |  |  |  | Fourth Test