Spreadsheet: 818104d1676587833-formula-to-setup-biweekly-pay-period-in-excel-pay-period-dates-setup_sample2
Sheet: Biweekly

Pay Periods - If the dates fall on a holiday or weekend, the pay date will be the workday before. |  |  |  |  |  |  |  | Date | Holiday | Day
Begins |  | Ends |  | Pay Day |  | Pay Day - Accounting for Holidays |  | 2023-01-01 00:00:00 | New Year's Day | Sunday
2023-01-01 00:00:00 |  | 2023-01-14 00:00:00 |  | 2023-01-20 00:00:00 |  | 2023-01-20 00:00:00 |  | 2023-01-16 00:00:00 | [NAME] | Monday
2023-01-15 00:00:00 |  | 2023-01-28 00:00:00 |  | 2023-02-03 00:00:00 |  | 2023-02-03 00:00:00 |  | 2023-01-24 00:00:00 | Belly Laugh Day | Tuesday
2023-01-29 00:00:00 |  | 2023-02-11 00:00:00 |  | 2023-02-17 00:00:00 |  | 2023-02-17 00:00:00 |  | 2023-02-02 00:00:00 | Groundhog Day | Thursday
2023-02-12 00:00:00 |  | 2023-02-25 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-03-03 00:00:00 |  | 2023-02-12 00:00:00 | Lincoln's Birthday | Sunday
2023-02-26 00:00:00 |  | 2023-03-11 00:00:00 |  | 2023-03-17 00:00:00 |  | 2023-03-16 00:00:00 |  | 2023-02-14 00:00:00 | [NAME]'s Day | Tuesday
2023-03-12 00:00:00 |  | 2023-03-25 00:00:00 |  | 2023-03-31 00:00:00 |  | 2023-03-31 00:00:00 |  | 2023-02-20 00:00:00 | Presidents Day and Washington's Birthday | Monday
2023-03-26 00:00:00 |  | 2023-04-08 00:00:00 |  | 2023-04-14 00:00:00 |  | 2023-04-14 00:00:00 |  | 2023-02-21 00:00:00 | [NAME] | Tuesday
2023-04-09 00:00:00 |  | 2023-04-22 00:00:00 |  | 2023-04-28 00:00:00 |  | 2023-04-28 00:00:00 |  | 2023-03-12 00:00:00 | Daylight Saving | Sunday
2023-04-23 00:00:00 |  | 2023-05-06 00:00:00 |  | 2023-05-12 00:00:00 |  | 2023-05-12 00:00:00 |  | 2023-03-17 00:00:00 | St. Patrick's Day | Friday
2023-05-07 00:00:00 |  | 2023-05-20 00:00:00 |  | 2023-05-26 00:00:00 |  | 2023-05-26 00:00:00 |  | 2023-04-01 00:00:00 | April Fool's Day | Saturday
2023-05-21 00:00:00 |  | 2023-06-03 00:00:00 |  | 2023-06-09 00:00:00 |  | 2023-06-09 00:00:00 |  | 2023-04-07 00:00:00 | Good Friday | Friday
2023-06-04 00:00:00 |  | 2023-06-17 00:00:00 |  | 2023-06-23 00:00:00 |  | 2023-06-23 00:00:00 |  | 2023-04-09 00:00:00 | Easter | Sunday
2023-06-18 00:00:00 |  | 2023-07-01 00:00:00 |  | 2023-07-07 00:00:00 |  | 2023-07-07 00:00:00 |  | 2023-04-10 00:00:00 | Easter Monday | Monday
2023-07-02 00:00:00 |  | 2023-07-15 00:00:00 |  | 2023-07-21 00:00:00 |  | 2023-07-21 00:00:00 |  | 2023-04-22 00:00:00 | Earth Day | Saturday
2023-07-16 00:00:00 |  | 2023-07-29 00:00:00 |  | 2023-08-04 00:00:00 |  | 2023-08-04 00:00:00 |  | 2023-05-05 00:00:00 | Cinco de Mayo | Friday
2023-07-30 00:00:00 |  | 2023-08-12 00:00:00 |  | 2023-08-18 00:00:00 |  | 2023-08-18 00:00:00 |  | 2023-05-14 00:00:00 | Mother's Day | Sunday
2023-08-13 00:00:00 |  | 2023-08-26 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-09-01 00:00:00 |  | 2023-05-20 00:00:00 | Armed Forces Day | Saturday
2023-08-27 00:00:00 |  | 2023-09-09 00:00:00 |  | 2023-09-15 00:00:00 |  | 2023-09-15 00:00:00 |  | 2023-05-28 00:00:00 | Pentecost | Sunday
2023-09-10 00:00:00 |  | 2023-09-23 00:00:00 |  | 2023-09-29 00:00:00 |  | 2023-09-29 00:00:00 |  | 2023-05-29 00:00:00 | Memorial Day | Monday
2023-09-24 00:00:00 |  | 2023-10-07 00:00:00 |  | 2023-10-13 00:00:00 |  | 2023-10-13 00:00:00 |  | 2023-05-29 00:00:00 | Pentecost Monday | Monday
2023-10-08 00:00:00 |  | 2023-10-21 00:00:00 |  | 2023-10-27 00:00:00 |  | 2023-10-27 00:00:00 |  | 2023-06-14 00:00:00 | Flag Day | Wednesday
2023-10-22 00:00:00 |  | 2023-11-04 00:00:00 |  | 2023-11-10 00:00:00 |  | 2023-11-10 00:00:00 |  | 2023-06-18 00:00:00 | Father's Day | Sunday
2023-11-05 00:00:00 |  | 2023-11-18 00:00:00 |  | 2023-11-24 00:00:00 |  | 2023-11-24 00:00:00 |  | 2023-07-04 00:00:00 | Independence Day | Tuesday
2023-11-19 00:00:00 |  | 2023-12-02 00:00:00 |  | 2023-12-08 00:00:00 |  | 2023-12-08 00:00:00 |  | 2023-07-23 00:00:00 | Parents' Day | Sunday
2023-12-03 00:00:00 |  | 2023-12-16 00:00:00 |  | 2023-12-22 00:00:00 |  | 2023-12-22 00:00:00 |  | 2023-09-04 00:00:00 | Labor Day | Monday
2023-12-17 00:00:00 |  | 2023-12-30 00:00:00 |  | 2024-01-05 00:00:00 |  | 2024-01-05 00:00:00 |  | 2023-09-10 00:00:00 | Grandparents' Day | Sunday
2023-12-31 00:00:00 |  | 2024-01-13 00:00:00 |  | 2024-01-19 00:00:00 |  | 2024-01-19 00:00:00 |  | 2023-09-11 00:00:00 | Patriot Day or September 11th | Monday
 |  |  |  |  |  |  |  | 2023-09-16 00:00:00 | Stepfamily Day | Saturday
 |  |  |  |  |  |  |  | 2023-09-17 00:00:00 | Citizenship Day | Sunday
 |  |  |  |  |  |  |  | 2023-09-22 00:00:00 | Native American Day | Friday
 |  |  |  |  |  |  |  | 2023-10-09 00:00:00 | Columbus Day | Monday
 |  |  |  |  |  |  |  | 2023-10-16 00:00:00 | Boss's Day | Monday
 |  |  |  |  |  |  |  | 2023-10-21 00:00:00 | Sweetest Day | Saturday
 |  |  |  |  |  |  |  | 2023-10-31 00:00:00 | Halloween | Tuesday
 |  |  |  |  |  |  |  | 2023-11-05 00:00:00 | Daylight Saving | Sunday
 |  |  |  |  |  |  |  | 2023-11-11 00:00:00 | Veterans' Day | Saturday
 |  |  |  |  |  |  |  | 2023-11-23 00:00:00 | Thanksgiving | Thursday
 |  |  |  |  |  |  |  | 2023-11-24 00:00:00 | Black Friday | Friday
 |  |  |  |  |  |  |  | 2023-11-27 00:00:00 | Cyber Monday | Monday
 |  |  |  |  |  |  |  | 2023-12-07 00:00:00 | Pearl Harbor Remembrance Day | Thursday
 |  |  |  |  |  |  |  | 2023-12-25 00:00:00 | Christmas Day | Monday
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 | New Year's Eve | Sunday