Spreadsheet: 818112d1676595740-formula-to-setup-biweekly-pay-period-in-excel-1910-pay-period-dates
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-16 00:00:00 | [NAME] | Monday
 |  |  |  |  |  |  |  | 2023-01-24 00:00:00 | Belly Laugh Day | Tuesday
 |  |  |  |  |  |  |  | 2023-02-02 00:00:00 | Groundhog Day | Thursday
 |  |  |  |  |  |  |  | 2023-02-12 00:00:00 | Lincoln's Birthday | Sunday
 |  |  |  |  |  |  |  | 2023-02-14 00:00:00 | [NAME]'s Day | Tuesday
 |  |  |  |  |  |  |  | 2023-02-20 00:00:00 | Presidents Day and Washington's Birthday | Monday
 |  |  |  |  |  |  |  | 2023-02-21 00:00:00 | [NAME] | Tuesday
 |  |  |  |  |  |  |  | 2023-03-12 00:00:00 | Daylight Saving | Sunday
 |  |  |  |  |  |  |  | 2023-03-17 00:00:00 | St. Patrick's Day | Friday
 |  |  |  |  |  |  |  | 2023-04-01 00:00:00 | April Fool's Day | Saturday
 |  |  |  |  |  |  |  | 2023-04-07 00:00:00 | Good Friday | Friday
 |  |  |  |  |  |  |  | 2023-04-09 00:00:00 | Easter | Sunday
 |  |  |  |  |  |  |  | 2023-04-10 00:00:00 | Easter Monday | Monday
 |  |  |  |  |  |  |  | 2023-04-22 00:00:00 | Earth Day | Saturday
 |  |  |  |  |  |  |  | 2023-05-05 00:00:00 | Cinco de Mayo | Friday
 |  |  |  |  |  |  |  | 2023-05-14 00:00:00 | Mother's Day | Sunday
 |  |  |  |  |  |  |  | 2023-05-20 00:00:00 | Armed Forces Day | Saturday
 |  |  |  |  |  |  |  | 2023-05-28 00:00:00 | Pentecost | Sunday
 |  |  |  |  |  |  |  | 2023-05-29 00:00:00 | Memorial Day | Monday
 |  |  |  |  |  |  |  | 2023-05-29 00:00:00 | Pentecost Monday | Monday
 |  |  |  |  |  |  |  | 2023-06-14 00:00:00 | Flag Day | Wednesday
 |  |  |  |  |  |  |  | 2023-06-18 00:00:00 | Father's Day | Sunday
 |  |  |  |  |  |  |  | 2023-07-04 00:00:00 | Independence Day | Tuesday
 |  |  |  |  |  |  |  | 2023-07-23 00:00:00 | Parents' Day | Sunday
 |  |  |  |  |  |  |  | 2023-09-04 00:00:00 | Labor Day | Monday
 |  |  |  |  |  |  |  | 2023-09-10 00:00:00 | Grandparents' Day | Sunday
 |  |  |  |  |  |  |  | 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