Spreadsheet: 849980d1700353992-calculating-paydates-business-rules-for-sat-sun-mon-calculate-pay-dates
Sheet: Sheet1

Start Date: | 2023-12-31 00:00:00
Pay Day | Pay Date | EOMonth | Business Rule | Actual Pay Date (Manual Entry) | Actual Pay Date (Automated) |  | Excel 2016 / 2019 | Excel 365 / 2021
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-01-05 00:00:00
22nd |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-01-20 00:00:00 |  |  | 2024-01-20 00:00:00 | 2024-01-20 00:00:00
7th |  |  | Ok | 2024-02-07 00:00:00 |  |  | 2024-02-07 00:00:00 | 2024-02-07 00:00:00
22nd |  |  | Ok | 2024-02-22 00:00:00 |  |  | 2024-02-22 00:00:00 | 2024-02-22 00:00:00
7th |  |  | Ok | 2024-03-07 00:00:00 |  |  | 2024-03-07 00:00:00 | 2024-03-07 00:00:00
22nd |  |  | Ok | 2024-03-22 00:00:00 |  |  | 2024-03-22 00:00:00 | 2024-03-22 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-04-05 00:00:00 |  |  | 2024-04-05 00:00:00 | 2024-04-05 00:00:00
22nd |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-04-20 00:00:00 |  |  | 2024-04-20 00:00:00 | 2024-04-20 00:00:00
7th |  |  | Ok | 2024-05-07 00:00:00 |  |  | 2024-05-07 00:00:00 | 2024-05-07 00:00:00
22nd |  |  | Ok | 2024-05-22 00:00:00 |  |  | 2024-05-22 00:00:00 | 2024-05-22 00:00:00
7th |  |  | Ok | 2024-06-07 00:00:00 |  |  | 2024-06-07 00:00:00 | 2024-06-07 00:00:00
22nd |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-06-21 00:00:00 |  |  | 2024-06-21 00:00:00 | 2024-06-21 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-07-05 00:00:00 |  |  | 2024-07-05 00:00:00 | 2024-07-05 00:00:00
22nd |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-07-20 00:00:00 |  |  | 2024-07-20 00:00:00 | 2024-07-20 00:00:00
7th |  |  | Ok | 2024-08-07 00:00:00 |  |  | 2024-08-07 00:00:00 | 2024-08-07 00:00:00
22nd |  |  | Ok | 2024-08-22 00:00:00 |  |  | 2024-08-22 00:00:00 | 2024-08-22 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-09-06 00:00:00 |  |  | 2024-09-06 00:00:00 | 2024-09-06 00:00:00
22nd |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-09-20 00:00:00 |  |  | 2024-09-20 00:00:00 | 2024-09-20 00:00:00
7th |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-10-05 00:00:00 |  |  | 2024-10-05 00:00:00 | 2024-10-05 00:00:00
22nd |  |  | Ok | 2024-10-22 00:00:00 |  |  | 2024-10-22 00:00:00 | 2024-10-22 00:00:00
7th |  |  | Ok | 2024-11-07 00:00:00 |  |  | 2024-11-07 00:00:00 | 2024-11-07 00:00:00
22nd |  |  | Ok | 2024-11-22 00:00:00 |  |  | 2024-11-22 00:00:00 | 2024-11-22 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-12-06 00:00:00 |  |  | 2024-12-06 00:00:00 | 2024-12-06 00:00:00
22nd |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-12-20 00:00:00 |  |  | 2024-12-20 00:00:00 | 2024-12-20 00:00:00