Spreadsheet: 862977d1710525206-biweekly-payroll-formula-sample-pay-period-spreadsheet
Sheet: Sheet1

 | PAY PERIOD NUMBER |  |  | BIWK1 Pay Period End Date | PAYROLL # |  |  |  |  |  | Month | FY PP Number | Payroll #
 | 1 | 2020-12-23 00:00:00 | 2020-12-25 00:00:00 | 2020-12-27 00:00:00 | 1 - JAN | 2021-01-05 00:00:00 | 2021-01-05 00:00:00 | 2021-01-06 00:00:00 | 2021-01-07 00:00:00 | 2021-01-08 00:00:00 | 1 |  | 1
 | 2 | 2021-01-06 00:00:00 | 2021-01-08 00:00:00 | 2021-01-10 00:00:00 | 2 - JAN | 2021-01-19 00:00:00 | 2021-01-19 00:00:00 | 2021-01-20 00:00:00 | 2021-01-21 00:00:00 | 2021-01-22 00:00:00 | 1 |  | 2
 | 3 | 2021-01-20 00:00:00 | 2021-01-22 00:00:00 | 2021-01-24 00:00:00 | 1 - FEB | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-05 00:00:00 | 2 |  | 1
 | 4 | 2021-02-03 00:00:00 | 2021-02-05 00:00:00 | 2021-02-07 00:00:00 | 2 - FEB | 2021-02-16 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2 |  | 2
 | 5 | 2021-02-17 00:00:00 | 2021-02-19 00:00:00 | 2021-02-21 00:00:00 | 1 - MAR | 2021-03-01 00:00:00 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-03 00:00:00 | 2021-03-05 00:00:00 | 3 |  | 1
 | 6 | 2021-03-03 00:00:00 | 2021-03-05 00:00:00 | 2021-03-07 00:00:00 | 2 - MAR | 2021-03-15 00:00:00 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | 2021-03-17 00:00:00 | 2021-03-19 00:00:00 | 3 |  | 2
 | 7 | 2021-03-17 00:00:00 | 2021-03-19 00:00:00 | 2021-03-21 00:00:00 | 3 - MAR | 2021-03-26 00:00:00 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | 2021-03-31 00:00:00 | 2021-04-02 00:00:00 | 4 |  | 1
 | 8 | 2021-03-31 00:00:00 | 2021-04-02 00:00:00 | 2021-04-04 00:00:00 | 1 - APR | 2021-04-12 00:00:00 | 2021-04-12 00:00:00 | 2021-04-13 00:00:00 | 2021-04-14 00:00:00 | 2021-04-16 00:00:00 | 4 |  | 2
 | 9 | 2021-04-14 00:00:00 | 2021-04-16 00:00:00 | 2021-04-18 00:00:00 | 2 - APR | 2021-04-26 00:00:00 | 2021-04-26 00:00:00 | 2021-04-27 00:00:00 | 2021-04-28 00:00:00 | 2021-04-30 00:00:00 | 4 |  | 3
 | 10 | 2021-04-28 00:00:00 | 2021-04-30 00:00:00 | 2021-05-02 00:00:00 | 1 - MAY | 2021-05-10 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-14 00:00:00 | 5 |  | 1
 | 11 | 2021-05-12 00:00:00 | 2021-05-14 00:00:00 | 2021-05-16 00:00:00 | 2 - MAY | 2021-05-24 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 | 2021-05-28 00:00:00 | 5 |  | 2
 | 12 | 2021-05-26 00:00:00 | 2021-05-28 00:00:00 | 2021-05-30 00:00:00 | 1 - JUN | 2021-06-07 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-11 00:00:00 | 6 |  | 1
 | 13 | 2021-06-09 00:00:00 | 2021-06-11 00:00:00 | 2021-06-13 00:00:00 | 2 - JUN | 2021-06-21 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-25 00:00:00 | 6 |  | 2
 | 14 | 2021-06-23 00:00:00 | 2021-06-25 00:00:00 | 2021-06-27 00:00:00 | 1 - JUL | 2021-07-06 00:00:00 | 2021-07-06 00:00:00 | 2021-07-07 00:00:00 | 2021-07-08 00:00:00 | 2021-07-09 00:00:00 | 7 |  | 1
 | 15 | 2021-07-07 00:00:00 | 2021-07-09 00:00:00 | 2021-07-11 00:00:00 | 2 - JUL | 2021-07-19 00:00:00 | 2021-07-19 00:00:00 | 2021-07-20 00:00:00 | 2021-07-21 00:00:00 | 2021-07-23 00:00:00 | 7 | 1 | 2
 | 16 | 2021-07-21 00:00:00 | 2021-07-23 00:00:00 | 2021-07-25 00:00:00 | 1 - AUG | 2021-08-02 00:00:00 | 2021-08-02 00:00:00 | 2021-08-03 00:00:00 | 2021-08-04 00:00:00 | 2021-08-06 00:00:00 | 8 | 2 | 1
 | 17 | 2021-08-04 00:00:00 | 2021-08-06 00:00:00 | 2021-08-08 00:00:00 | 2 - AUG | 2021-08-16 00:00:00 | 2021-08-16 00:00:00 | 2021-08-17 00:00:00 | 2021-08-18 00:00:00 | 2021-08-20 00:00:00 | 8 | 3 | 2
 | 18 | 2021-08-18 00:00:00 | 2021-08-20 00:00:00 | 2021-08-22 00:00:00 | 1 - SEP | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 2021-08-31 00:00:00 | 2021-09-01 00:00:00 | 2021-09-03 00:00:00 | 9 | 4 | 1
 | 19 | 2021-09-01 00:00:00 | 2021-09-03 00:00:00 | 2021-09-05 00:00:00 | 2 - SEP | 2021-09-13 00:00:00 | 2021-09-13 00:00:00 | 2021-09-14 00:00:00 | 2021-09-15 00:00:00 | 2021-09-17 00:00:00 | 9 | 5 | 2
 | 20 | 2021-09-15 00:00:00 | 2021-09-17 00:00:00 | 2021-09-19 00:00:00 | 3 - SEP | 2021-09-27 00:00:00 | 2021-09-27 00:00:00 | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-10-01 00:00:00 | 10 | 6 | 1
 | 21 | 2021-09-29 00:00:00 | 2021-10-01 00:00:00 | 2021-10-03 00:00:00 | 1 - OCT | 2021-10-11 00:00:00 | 2021-10-11 00:00:00 | 2021-10-12 00:00:00 | 2021-10-13 00:00:00 | 2021-10-15 00:00:00 | 10 | 7 | 2
 | 22 | 2021-10-13 00:00:00 | 2021-10-15 00:00:00 | 2021-10-17 00:00:00 | 2 - OCT | 2021-10-25 00:00:00 | 2021-10-25 00:00:00 | 2021-10-26 00:00:00 | 2021-10-27 00:00:00 | 2021-10-29 00:00:00 | 10 | 8 | 3
 | 23 | 2021-10-27 00:00:00 | 2021-10-29 00:00:00 | 2021-10-31 00:00:00 | 1 - NOV | 2021-11-08 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-12 00:00:00 | 11 | 9 | 1
 | 24 | 2021-11-10 00:00:00 | 2021-11-12 00:00:00 | 2021-11-14 00:00:00 | 2 - NOV | 2021-11-22 00:00:00 | 2021-11-22 00:00:00 | 2021-11-23 00:00:00 | 2021-11-24 00:00:00 | 2021-11-26 00:00:00 | 11 | 10 | 2
 | 25 | 2021-11-24 00:00:00 | 2021-11-26 00:00:00 | 2021-11-28 00:00:00 | 1 - DEC | 2021-12-06 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-10 00:00:00 | 12 | 11 | 1
 | 26 | 2021-12-08 00:00:00 | 2021-12-10 00:00:00 | 2021-12-12 00:00:00 | 2 - DEC | 2021-12-20 00:00:00 | 2021-12-20 00:00:00 | 2021-12-21 00:00:00 | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | 12 | 12 | 2
 | 1 | 2021-12-22 00:00:00 | 2021-12-24 00:00:00 | 2021-12-26 00:00:00 | 1 - Jan |  |  |  | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 1 | 13 | 1
 | 2 | 2022-01-05 00:00:00 | 2022-01-07 00:00:00 | 2022-01-09 00:00:00 | 2 - Jan |  |  |  | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 1 | 14 | 2 | 1/17 is MLK observed
 | 3 | 2022-01-19 00:00:00 | 2022-01-21 00:00:00 | 2022-01-23 00:00:00 | 1 - Feb |  |  |  | 2022-02-02 00:00:00 | 2022-02-04 00:00:00 | 2 | 15 | 1
 | 4 | 2022-02-02 00:00:00 | 2022-02-04 00:00:00 | 2022-02-06 00:00:00 | 2 - Feb |  |  |  | 2022-02-16 00:00:00 | 2022-02-18 00:00:00 | 2 | 16 | 2
 | 5 | 2022-02-16 00:00:00 | 2022-02-18 00:00:00 | 2022-02-20 00:00:00 | 1 - Mar |  |  |  | 2022-03-02 00:00:00 | 2022-03-04 00:00:00 | 3 | 17 | 1
 | 6 | 2022-03-02 00:00:00 | 2022-03-04 00:00:00 | 2022-03-06 00:00:00 | 2 - Mar |  |  |  | 2022-03-16 00:00:00 | 2022-03-18 00:00:00 | 3 | 18 | 2
 | 7 | 2022-03-16 00:00:00 | 2022-03-18 00:00:00 | 2022-03-20 00:00:00 | 2 - Mar |  |  |  | 2022-03-31 00:00:00 | 2022-04-01 00:00:00 | 4 | 19 | 3 | Overrode formula to match payroll calendar
 | 8 | 2022-03-30 00:00:00 | 2022-04-01 00:00:00 | 2022-04-03 00:00:00 | 2 - Apr |  |  |  | 2022-04-13 00:00:00 | 2022-04-15 00:00:00 | 4 | 20 | 1 | Overrode formula to match payroll calendar
 | 9 | 2022-04-13 00:00:00 | 2022-04-15 00:00:00 | 2022-04-17 00:00:00 | 3 - Apr |  |  |  | 2022-04-27 00:00:00 | 2022-04-29 00:00:00 | 4 | 21 | 2 | Overrode formula to match payroll calendar
 | 10 | 2022-04-27 00:00:00 | 2022-04-29 00:00:00 | 2022-05-01 00:00:00 | 1 - May |  |  |  | 2022-05-11 00:00:00 | 2022-05-13 00:00:00 | 5 | 22 | 1
 | 11 | 2022-05-11 00:00:00 | 2022-05-13 00:00:00 | 2022-05-15 00:00:00 | 2 - May |  |  |  | 2022-05-25 00:00:00 | 2022-05-27 00:00:00 | 5 | 23 | 2
 | 12 | 2022-05-25 00:00:00 | 2022-05-27 00:00:00 | 2022-05-29 00:00:00 | 1 - Jun |  |  |  | 2022-06-08 00:00:00 | 2022-06-10 00:00:00 | 6 | 24 | 1
 | 13 | 2022-06-08 00:00:00 | 2022-06-10 00:00:00 | 2022-06-12 00:00:00 | 2 - Jun |  |  |  | 2022-06-22 00:00:00 | 2022-06-24 00:00:00 | 6 | 25 | 2
 | 14 | 2022-06-22 00:00:00 | 2022-06-24 00:00:00 | 2022-06-26 00:00:00 | 1 - Jul |  |  |  | 2022-07-07 00:00:00 | 2022-07-08 00:00:00 | 6 | 26 | 1 | Last full pay period of FY2022
 | 15 | 2022-07-06 00:00:00 | 2022-07-08 00:00:00 | 2022-07-10 00:00:00 | 2 - Jul |  |  |  | 2022-07-20 00:00:00 | 2022-07-22 00:00:00 | 7 | 1 | 2 | Partial pay period for FY2022 - 1/10 paid days
 | 16 | 2022-07-20 00:00:00 | 2022-07-22 00:00:00 | 2022-07-24 00:00:00 | 1 - Aug |  |  |  | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | 8 | 2 | 1
 | 17 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | 2022-08-07 00:00:00 | 2 - Aug |  |  |  | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | 8 | 3 | 2
 | 18 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | 2022-08-21 00:00:00 | 3 - Aug |  |  |  | 2022-08-31 00:00:00 | 2022-09-02 00:00:00 | 9 | 4 | 3
 | 19 | 2022-08-31 00:00:00 | 2022-09-02 00:00:00 | 2022-09-04 00:00:00 | 1 - Sep |  |  |  | 2022-09-14 00:00:00 | 2022-09-16 00:00:00 | 9 | 5 | 1
 | 20 | 2022-09-14 00:00:00 | 2022-09-16 00:00:00 | 2022-09-18 00:00:00 | 2 - Sep |  |  |  | 2022-09-28 00:00:00 | 2022-09-30 00:00:00 | 9 | 6 | 2
 | 21 | 2022-09-28 00:00:00 | 2022-09-30 00:00:00 | 2022-10-02 00:00:00 | 1 - Oct |  |  |  | 2022-10-12 00:00:00 | 2022-10-14 00:00:00 | 10 | 7 | 1
 | 22 | 2022-10-12 00:00:00 | 2022-10-14 00:00:00 | 2022-10-16 00:00:00 | 2 - Oct |  |  |  | 2022-10-26 00:00:00 | 2022-10-28 00:00:00 | 10 | 8 | 2
 | 23 | 2022-10-26 00:00:00 | 2022-10-28 00:00:00 | 2022-10-30 00:00:00 | 1 - Nov |  |  |  | 2022-11-09 00:00:00 | 2022-11-10 00:00:00 | 11 | 9 | 1
 | 24 | 2022-11-09 00:00:00 | 2022-11-11 00:00:00 | 2022-11-13 00:00:00 | 2 - Nov |  |  |  | 2022-11-23 00:00:00 | 2022-11-25 00:00:00 | 11 | 10 | 2
 | 25 | 2022-11-23 00:00:00 | 2022-11-25 00:00:00 | 2022-11-27 00:00:00 | 1 - Dec |  |  |  | 2022-12-07 00:00:00 | 2022-12-09 00:00:00 | 12 | 11 | 1
 | 26 | 2022-12-07 00:00:00 | 2022-12-09 00:00:00 | 2022-12-11 00:00:00 | 2 - Dec |  |  |  | 2022-12-21 00:00:00 | 2022-12-23 00:00:00 | 12 | 12 | 2
 | 1 | 2022-12-21 00:00:00 | 2022-12-23 00:00:00 | 2022-12-25 00:00:00 | 1 - Jan |  |  |  | 2023-01-04 00:00:00 | 2023-01-06 00:00:00 | 1 | 13 | 1
 | 2 | 2023-01-04 00:00:00 | 2023-01-06 00:00:00 | 2023-01-08 00:00:00 | 2 - Jan |  |  |  | 2023-01-18 00:00:00 | 2023-01-20 00:00:00 | 1 | 14 | 2
 | 3 | 2023-01-18 00:00:00 | 2023-01-20 00:00:00 | 2023-01-22 00:00:00 | 1 - Feb |  |  |  | 2023-02-01 00:00:00 | 2023-02-03 00:00:00 | 2 | 15 | 1
 | 4 | 2023-02-01 00:00:00 | 2023-02-03 00:00:00 | 2023-02-05 00:00:00 | 2 - Feb |  |  |  | 2023-02-15 00:00:00 | 2023-02-17 00:00:00 | 2 | 16 | 2
 | 5 | 2023-02-15 00:00:00 | 2023-02-17 00:00:00 | 2023-02-19 00:00:00 | 1 - Mar |  |  |  | 2023-03-01 00:00:00 | 2023-03-03 00:00:00 | 3 | 17 | 1
 | 6 | 2023-03-01 00:00:00 | 2023-03-03 00:00:00 | 2023-03-05 00:00:00 | 2 - Mar |  |  |  | 2023-03-15 00:00:00 | 2023-03-17 00:00:00 | 3 | 18 | 2
 | 7 | 2023-03-15 00:00:00 | 2023-03-17 00:00:00 | 2023-03-19 00:00:00 | 3 - Mar |  |  |  | 2023-03-29 00:00:00 | 2023-03-31 00:00:00 | 3 | 19 | 3
 | 8 | 2023-03-29 00:00:00 | 2023-03-31 00:00:00 | 2023-04-02 00:00:00 | 1 - Apr |  |  |  | 2023-04-12 00:00:00 | 2023-04-14 00:00:00 | 4 | 20 | 1
 | 9 | 2023-04-12 00:00:00 | 2023-04-14 00:00:00 | 2023-04-16 00:00:00 | 2 - Apr |  |  |  | 2023-04-26 00:00:00 | 2023-04-28 00:00:00 | 4 | 21 | 2
 | 10 | 2023-04-26 00:00:00 | 2023-04-28 00:00:00 | 2023-04-30 00:00:00 | 1 - May |  |  |  | 2023-05-10 00:00:00 | 2023-05-12 00:00:00 | 5 | 22 | 1
 | 11 | 2023-05-10 00:00:00 | 2023-05-12 00:00:00 | 2023-05-14 00:00:00 | 2 - May |  |  |  | 2023-05-24 00:00:00 | 2023-05-26 00:00:00 | 5 | 23 | 2
 | 12 | 2023-05-24 00:00:00 | 2023-05-26 00:00:00 | 2023-05-28 00:00:00 | 1 - Jun |  |  |  | 2023-06-07 00:00:00 | 2023-06-09 00:00:00 | 6 | 24 | 1
 | 13 | 2023-06-07 00:00:00 | 2023-06-09 00:00:00 | 2023-06-11 00:00:00 | 2 - Jun |  |  |  | 2023-06-21 00:00:00 | 2023-06-23 00:00:00 | 6 | 25 | 2
 | 14 | 2023-06-21 00:00:00 | 2023-06-23 00:00:00 | 2023-06-25 00:00:00 | 1 - Jul |  |  |  | 2023-07-05 00:00:00 | 2023-07-07 00:00:00 | 7 | 26 | 1 | Last full pay period of FY2023
 | 15 | 2023-07-05 00:00:00 | 2023-07-07 00:00:00 | 2023-07-09 00:00:00 | 1 - Jul |  |  |  | 2023-07-19 00:00:00 | 2023-07-21 00:00:00 | 7 | 1 | 2 | Partial pay period for FY2023 - 5/10 paid days
 | 16 | 2023-07-19 00:00:00 | 2023-07-21 00:00:00 | 2023-07-23 00:00:00 | 2 - Aug |  |  |  | 2023-08-02 00:00:00 | 2023-08-04 00:00:00 | 8 | 2 | 1
 | 17 | 2023-08-02 00:00:00 | 2023-08-04 00:00:00 | 2023-08-06 00:00:00 | 3 - Aug |  |  |  | 2023-08-16 00:00:00 | 2023-08-18 00:00:00 | 8 | 3 | 2
 | 18 | 2023-08-16 00:00:00 | 2023-08-18 00:00:00 | 2023-08-20 00:00:00 | 1 - Sep |  |  |  | 2023-08-30 00:00:00 | 2023-09-01 00:00:00 | 9 | 4 | 1
 | 19 | 2023-08-30 00:00:00 | 2023-09-01 00:00:00 | 2023-09-03 00:00:00 | 2 - Sep |  |  |  | 2023-09-13 00:00:00 | 2023-09-15 00:00:00 | 9 | 5 | 2
 | 20 | 2023-09-13 00:00:00 | 2023-09-15 00:00:00 | 2023-09-17 00:00:00 | 3 - Sep |  |  |  | 2023-09-27 00:00:00 | 2023-09-29 00:00:00 | 9 | 6 | 3
 | 21 | 2023-09-27 00:00:00 | 2023-09-29 00:00:00 | 2023-10-01 00:00:00 | 1 - Oct |  |  |  | 2023-10-11 00:00:00 | 2023-10-13 00:00:00 | 10 | 7 | 1
 | 22 | 2023-10-11 00:00:00 | 2023-10-13 00:00:00 | 2023-10-15 00:00:00 | 2 - Oct |  |  |  | 2023-10-25 00:00:00 | 2023-10-27 00:00:00 | 10 | 8 | 2
 | 23 | 2023-10-25 00:00:00 | 2023-10-27 00:00:00 | 2023-10-29 00:00:00 | 1 - Nov |  |  |  | 2023-11-08 00:00:00 | 2023-11-10 00:00:00 | 11 | 9 | 1
 | 24 | 2023-11-08 00:00:00 | 2023-11-10 00:00:00 | 2023-11-12 00:00:00 | 2 - Nov |  |  |  | 2023-11-22 00:00:00 | 2023-11-24 00:00:00 | 11 | 10 | 2
 | 25 | 2023-11-22 00:00:00 | 2023-11-24 00:00:00 | 2023-11-26 00:00:00 | 1 - Dec |  |  |  | 2023-12-06 00:00:00 | 2023-12-08 00:00:00 | 12 | 11 | 1
 | 26 | 2023-12-06 00:00:00 | 2023-12-08 00:00:00 | 2023-12-10 00:00:00 | 2 - Dec |  |  |  | 2023-12-20 00:00:00 | 2023-12-22 00:00:00 | 12 | 12 | 2
 | 27 | 2023-12-20 00:00:00 | 2023-12-22 00:00:00 | 2023-12-24 00:00:00 | 1 - Jan |  |  |  | 2024-01-03 00:00:00 | 2024-01-05 00:00:00 | 1 | 13 | 3
 | 2 | 2024-01-04 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2 - Jan |  |  |  | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 1 | 14 | 2
 | 3 | 2024-01-18 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 1 - Feb |  |  |  | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2 | 15 | 1
 | 4 | 2024-02-01 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | 2 - Feb |  |  |  | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2 | 16 | 2
 | 5 | 2024-02-15 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 | 1 - Mar |  |  |  | 2024-03-01 00:00:00 | 2024-03-01 00:00:00 | 3 | 17 | 1
 | 6 | 2024-03-01 00:00:00 | 2024-03-03 00:00:00 | 2024-03-03 00:00:00 | 2 - Mar |  |  |  | 2024-03-15 00:00:00 | 2024-03-15 00:00:00 | 3 | 18 | 2
 | 7 | 2024-03-15 00:00:00 | 2024-03-17 00:00:00 | 2024-03-17 00:00:00 | 3 - Mar |  |  |  | 2024-03-29 00:00:00 | 2024-03-29 00:00:00 | 3 | 19 | 3
 | 8 | 2024-03-29 00:00:00 | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | 1 - Apr |  |  |  | 2024-04-12 00:00:00 | 2024-04-12 00:00:00 | 4 | 20 | 1 |  | Payroll through
 | 9 | 2024-04-12 00:00:00 | 2024-04-14 00:00:00 | 2024-04-14 00:00:00 | 2 - Apr |  |  |  | 2024-04-26 00:00:00 | 2024-04-26 00:00:00 | 4 | 21 | 2 |  | #1 this year
 | 10 | 2024-04-26 00:00:00 | 2024-04-28 00:00:00 | 2024-04-28 00:00:00 | 1 - May |  |  |  | 2024-05-10 00:00:00 | 2024-05-10 00:00:00 | 5 | 22 | 1 |  | #2 This Year
 | 11 | 2024-05-10 00:00:00 | 2024-05-12 00:00:00 | 2024-05-12 00:00:00 | 2 - May |  |  |  | 2024-05-24 00:00:00 | 2024-05-24 00:00:00 | 5 | 23 | 2 |  | #3 This Year
 | 12 | 2024-05-24 00:00:00 | 2024-05-26 00:00:00 | 2024-05-26 00:00:00 | 1 - Jun |  |  |  | 2024-06-07 00:00:00 | 2024-06-07 00:00:00 | 6 | 24 | 1 |  | #1 Remaining |  |  | ERROR; Should have been 4 not 3
 | 13 | 2024-06-07 00:00:00 | 2024-06-09 00:00:00 | 2024-06-09 00:00:00 | 2 - Jun |  |  |  | 2024-06-21 00:00:00 | 2024-06-21 00:00:00 | 6 | 25 | 2 |  | #2 Remaining
 | 14 | 2024-06-21 00:00:00 | 2024-06-23 00:00:00 | 2024-06-23 00:00:00 | 1 - Jul |  |  |  | 2024-07-05 00:00:00 | 2024-07-05 00:00:00 | 7 | 26 | 1 |  | #3 Remaining
 | 15 | 2024-07-05 00:00:00 | 2024-07-07 00:00:00 | 2024-07-07 00:00:00 | 1 - Jul |  |  |  | 2024-07-19 00:00:00 | 2024-07-19 00:00:00 | 7 | 1 | 1 | Partial pay period for FY2024 - 5/10 paid days | EOY Payroll Days | 5