Spreadsheet: 863630d1711038521-comparing-multiple-criteria-and-dates-to-return-a-value-or-other-value-sallycodeworkbook
Sheet: Sheet1

Client Name | Transaction Date | Account Code | Closing Date | End Date |  |  |  | start | end | eom1 | eom2 | eom3 | eom4 | [NAME] | eom6 |  | start | end | [NAME]
[NAME] | 2024-03-20 00:00:00 | [NAME] | 2024-03-21 00:00:00 | 2024-04-15 00:00:00 |  |  |  | 2023-10-06 00:00:00 | 2023-11-05 00:00:00 | 2023-11-30 00:00:00 | 2023-12-30 00:00:00 | 2023-01-30 00:00:00 | 2023-02-28 00:00:00 | 2023-03-30 00:00:00 | 2023-04-30 00:00:00 |  | 2023-10-06 00:00:00 | 2023-11-05 00:00:00 | 2024-11-15 00:00:00 | 2024-12-30 00:00:00
[NAME] | 2024-04-20 00:00:00 | [NAME] | 2024-05-16 00:00:00 | 2024-06-30 00:00:00 |  |  |  | 2023-11-06 00:00:00 | 2023-12-05 00:00:00 | 2023-12-30 00:00:00 | 2023-01-30 00:00:00 | 2023-02-28 00:00:00 | 2023-03-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-30 00:00:00 |  | 2023-11-06 00:00:00 | 2023-12-05 00:00:00 | 2024-12-15 00:00:00 | 2024-01-30 00:00:00
[NAME] | 2024-03-15 00:00:00 | NE601 |  |  |  |  |  | 2023-12-06 00:00:00 | 2023-01-05 00:00:00 | 2023-01-30 00:00:00 | 2023-02-28 00:00:00 | 2023-03-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-30 00:00:00 | 2023-06-30 00:00:00 |  | 2023-12-06 00:00:00 | 2023-01-05 00:00:00 | 2024-01-15 00:00:00 | 2024-02-28 00:00:00
Grace | 2024-03-15 00:00:00 | NE451 |  |  |  |  |  | 2023-01-06 00:00:00 | 2023-02-05 00:00:00 | 2023-02-28 00:00:00 | 2023-03-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-30 00:00:00 |  | 2023-01-06 00:00:00 | 2023-02-05 00:00:00 | 2024-02-15 00:00:00 | 2024-03-30 00:00:00
Quinn | 2024-02-15 00:00:00 | NE301 |  |  |  |  |  | 2023-02-06 00:00:00 | 2023-03-05 00:00:00 | 2023-03-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-30 00:00:00 | 2023-08-30 00:00:00 |  | 2023-02-06 00:00:00 | 2023-03-05 00:00:00 | 2024-03-15 00:00:00 | 2024-04-30 00:00:00
[NAME] | 2024-01-05 00:00:00 | [NAME] |  | 2024-05-30 00:00:00 |  |  |  | 2023-03-06 00:00:00 | 2023-04-05 00:00:00 | 2023-04-30 00:00:00 | 2023-05-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-30 00:00:00 | 2023-08-30 00:00:00 | 2023-09-30 00:00:00 |  | 2023-03-06 00:00:00 | 2023-04-05 00:00:00 | 2024-04-15 00:00:00 | 2024-05-30 00:00:00
[NAME] | 2024-02-21 00:00:00 | EOM4 |  | 2024-06-30 00:00:00 |  |  |  | 2023-04-06 00:00:00 | 2023-05-05 00:00:00 | 2023-05-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-30 00:00:00 | 2023-08-30 00:00:00 | 2023-09-30 00:00:00 | 2023-10-30 00:00:00 |  | 2023-04-06 00:00:00 | 2023-05-05 00:00:00 | 2024-05-15 00:00:00 | 2024-06-30 00:00:00
 |  |  |  |  |  |  |  | 2023-05-06 00:00:00 | 2023-06-05 00:00:00 | 2023-06-30 00:00:00 | 2023-07-30 00:00:00 | 2023-08-30 00:00:00 | 2023-09-30 00:00:00 | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 |  | 2023-05-06 00:00:00 | 2023-06-05 00:00:00 | 2024-06-15 00:00:00 | 2024-07-30 00:00:00
 |  |  |  |  |  |  |  | 2023-06-06 00:00:00 | 2023-07-05 00:00:00 | 2023-07-30 00:00:00 | 2023-08-30 00:00:00 | 2023-09-30 00:00:00 | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-30 00:00:00 |  | 2023-06-06 00:00:00 | 2023-07-05 00:00:00 | 2024-07-15 00:00:00 | 2024-08-30 00:00:00
 |  |  |  |  |  |  |  | 2023-07-06 00:00:00 | 2023-08-05 00:00:00 | 2023-08-30 00:00:00 | 2023-09-30 00:00:00 | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-30 00:00:00 | 2023-01-30 00:00:00 |  | 2023-07-06 00:00:00 | 2023-08-05 00:00:00 | 2024-08-15 00:00:00 | 2024-09-30 00:00:00
 |  |  |  |  |  |  |  | 2023-08-06 00:00:00 | 2023-09-05 00:00:00 | 2023-09-30 00:00:00 | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-30 00:00:00 | 2023-01-30 00:00:00 | 2/28 |  | 2023-08-06 00:00:00 | 2023-09-05 00:00:00 | 2024-09-15 00:00:00 | 2024-10-30 00:00:00
 |  |  |  |  |  |  |  | 2023-09-06 00:00:00 | 2023-10-05 00:00:00 | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-30 00:00:00 | 2023-01-30 00:00:00 | 2029-02-01 00:00:00 | 2023-03-30 00:00:00 |  | 2023-09-06 00:00:00 | 2023-10-05 00:00:00 | 2024-10-15 00:00:00 | 2024-11-30 00:00:00