Spreadsheet: 854470d1704336691-sumif-if-a-date-is-before-a-list-of-dates-excel-help-sample-
Sheet: Sheet1

Accrual Start Date | Sum of All Hours (beginning when the check date is after the accrual start date) | Check Date | Period Begin | Period End | Hours
2023-01-16 00:00:00 |  | 2023-01-24 00:00:00 | 2023-01-16 00:00:00 | 2023-01-29 00:00:00 | 0
2023-02-07 00:00:00 |  | 2023-01-27 00:00:00 | 2023-01-16 00:00:00 | 2023-01-29 00:00:00 | 45
2023-02-28 00:00:00 |  | 2023-02-02 00:00:00 | 2023-01-16 00:00:00 | 2023-01-21 00:00:00 | 56
2023-03-02 00:00:00 |  | 2023-02-03 00:00:00 | 2023-01-16 00:00:00 | 2023-01-29 00:00:00 | 12
2023-10-12 00:00:00 |  | 2023-02-06 00:00:00 | 2023-01-16 00:00:00 | 2023-01-24 00:00:00 | 45
2023-09-20 00:00:00 |  | 2023-02-07 00:00:00 | 2023-01-30 00:00:00 | 2023-02-07 00:00:00 | 0
2023-07-21 00:00:00 |  | 2023-02-10 00:00:00 | 2023-01-16 00:00:00 | 2023-01-29 00:00:00 | 1.5
2023-08-20 00:00:00 |  | 2023-02-17 00:00:00 | 2023-01-16 00:00:00 | 2023-01-29 00:00:00 | -1.5
 |  | 2023-02-20 00:00:00 | 2023-01-30 00:00:00 | 2023-02-17 00:00:00 | 15
 |  | 2023-02-22 00:00:00 | 2023-01-30 00:00:00 | 2023-02-12 00:00:00 | 2
 |  | 2023-02-24 00:00:00 | 2023-01-30 00:00:00 | 2023-02-12 00:00:00 | 68
 |  | 2023-02-28 00:00:00 | 2023-02-13 00:00:00 | 2023-02-25 00:00:00 | 0
 |  | 2023-03-02 00:00:00 | 2023-02-13 00:00:00 | 2023-03-01 00:00:00 | 0
 |  | 2023-03-03 00:00:00 | 2023-02-13 00:00:00 | 2023-02-26 00:00:00 | 0
 |  | 2023-03-07 00:00:00 | 2023-02-13 00:00:00 | 2023-02-26 00:00:00 | 8.75
 |  | 2023-03-13 00:00:00 | 2023-01-30 00:00:00 | 2023-02-14 00:00:00 | 48
 |  | 2023-03-16 00:00:00 | 2023-02-27 00:00:00 | 2023-03-13 00:00:00 | 0
 |  | 2023-03-17 00:00:00 | 2023-02-27 00:00:00 | 2023-03-12 00:00:00 | 0
 |  | 2023-06-21 00:00:00 | 2023-06-08 00:00:00 | 2023-06-14 00:00:00 | 0
 |  | 2023-06-22 00:00:00 | 2023-06-05 00:00:00 | 2023-06-20 00:00:00 | 24
 |  | 2023-06-23 00:00:00 | 2023-05-01 00:00:00 | 2023-05-31 00:00:00 | 0
 |  | 2023-06-27 00:00:00 | 2023-05-22 00:00:00 | 2023-06-04 00:00:00 | 0
 |  | 2023-06-28 00:00:00 | 2023-06-15 00:00:00 | 2023-06-21 00:00:00 | 0
 |  | 2023-10-02 00:00:00 | 2023-07-27 00:00:00 | 2023-08-02 00:00:00 | 0
 |  | 2023-10-04 00:00:00 | 2023-09-21 00:00:00 | 2023-09-27 00:00:00 | 0
 |  | 2023-10-06 00:00:00 | 2023-09-21 00:00:00 | 2023-09-29 00:00:00 | 0
 |  | 2023-10-11 00:00:00 | 2023-09-28 00:00:00 | 2023-10-04 00:00:00 | 0
 |  | 2023-10-17 00:00:00 | 2023-09-28 00:00:00 | 2023-10-08 00:00:00 | 0
 |  | 2023-10-18 00:00:00 | 2023-10-05 00:00:00 | 2023-10-11 00:00:00 | 0
 |  | 2023-10-20 00:00:00 | 2023-10-05 00:00:00 | 2023-10-09 00:00:00 | 0
 |  | 2023-10-24 00:00:00 | 2023-10-12 00:00:00 | 2023-10-22 00:00:00 | 0
 |  | 2023-10-25 00:00:00 | 2023-10-12 00:00:00 | 2023-10-18 00:00:00 | 0
 |  | 2023-10-26 00:00:00 | 2023-10-19 00:00:00 | 2023-10-25 00:00:00 | 0
 |  | 2023-10-27 00:00:00 | 2023-09-01 00:00:00 | 2023-09-30 00:00:00 | 0
 |  | 2023-10-31 00:00:00 | 2023-10-12 00:00:00 | 2023-10-18 00:00:00 | 0
 |  | 2023-11-01 00:00:00 | 2023-10-19 00:00:00 | 2023-10-25 00:00:00 | 0
 |  | 2023-11-07 00:00:00 | 2023-10-19 00:00:00 | 2023-10-25 00:00:00 | 0
 |  | 2023-11-08 00:00:00 | 2023-10-26 00:00:00 | 2023-11-01 00:00:00 | 0
 |  | 2023-11-14 00:00:00 | 2023-10-05 00:00:00 | 2023-10-12 00:00:00 | 0
 |  | 2023-11-15 00:00:00 | 2023-11-02 00:00:00 | 2023-11-08 00:00:00 | 0
 |  | 2023-11-16 00:00:00 | 2023-11-02 00:00:00 | 2023-11-08 00:00:00 | 0
 |  | 2023-11-21 00:00:00 | 2023-11-09 00:00:00 | 2023-11-18 00:00:00 | 0
 |  | 2023-11-22 00:00:00 | 2023-11-09 00:00:00 | 2023-11-15 00:00:00 | 0
 |  | 2023-11-24 00:00:00 | 2023-10-01 00:00:00 | 2023-10-31 00:00:00 | 0
 |  | 2023-11-28 00:00:00 | 2023-11-09 00:00:00 | 2023-11-15 00:00:00 | 0
 |  | 2023-11-29 00:00:00 | 2023-11-16 00:00:00 | 2023-11-22 00:00:00 | 0
 |  | 2023-12-01 00:00:00 | 2023-11-09 00:00:00 | 2023-11-15 00:00:00 | 0
 |  | 2023-12-05 00:00:00 | 2023-11-23 00:00:00 | 2023-11-30 00:00:00 | 0
 |  | 2023-12-06 00:00:00 | 2023-11-23 00:00:00 | 2023-11-29 00:00:00 | 0
 |  | 2023-12-11 00:00:00 | 2023-11-23 00:00:00 | 2023-11-29 00:00:00 | 0
 |  | 2023-12-12 00:00:00 | 2023-11-23 00:00:00 | 2023-11-29 00:00:00 | 0
 |  | 2023-12-13 00:00:00 | 2023-11-30 00:00:00 | 2023-12-06 00:00:00 | 0
 |  | 2023-12-14 00:00:00 | 2023-11-30 00:00:00 | 2023-12-06 00:00:00 | -40
 |  | 2023-12-15 00:00:00 | 2023-12-15 00:00:00 | 2023-12-15 00:00:00 | 0
 |  | 2023-12-19 00:00:00 | 2023-11-30 00:00:00 | 2023-12-06 00:00:00 | 0
 |  | 2023-12-20 00:00:00 | 2023-12-07 00:00:00 | 2023-12-13 00:00:00 | 0
 |  | 2023-12-22 00:00:00 | 2023-11-01 00:00:00 | 2023-11-30 00:00:00 | 0
 |  | 2023-12-26 00:00:00 | 2023-11-30 00:00:00 | 2023-12-06 00:00:00 | 0
 |  | 2023-12-27 00:00:00 | 2023-12-14 00:00:00 | 2023-12-20 00:00:00 | 0
 |  | 2023-12-29 00:00:00 | 2023-12-21 00:00:00 | 2023-12-26 00:00:00 | 0