Spreadsheet: 820699d1678260927-formula-for-pay-periods-numbering-leap-year-and-number-of-pay-periods-in-a-year-sample_paying-num_okay_use_use
Sheet: PY_Schedule (2)

Start Date | 2023-01-01 00:00:00 |  |  |  |  | Start Date | 2023-01-01 00:00:00 |  |  |  |  | Start Date | 2020-12-13 00:00:00 |  |  |  |  | Start Date | 2022-12-19 00:00:00 |  |  |  |  | Start Date | 2022-07-01 00:00:00 |  |  |  |  |  | Start Date | 2021-01-01 00:00:00 |  |  |  |  |  | Start Date | 2023-01-01 00:00:00
End Date |  | 1 |  |  |  | End Date | 2023-12-31 00:00:00 |  |  |  |  | End Date | 2021-12-31 00:00:00 |  |  |  |  | End Date | 2023-12-31 00:00:00 |  |  |  |  | End Date | 2023-06-30 00:00:00 |  |  |  |  |  | End Date | 2022-12-31 00:00:00 |  |  |  |  |  | End Date | 2023-12-31 00:00:00
 |  |  |  |  |  | Pay Frequency | Week | 6 |  |  |  | Pay Frequency | Weekly | 13 |  |  |  | Pay Frequency | Bi-weekly | 13 |  |  |  | Pay Frequency | Monthly | 1 |  |  |  |  | Pay Frequency | Monthly | 1 |  |  |  |  | Pay Frequency | Semimonthly | 2
Number of Sundays |  |  |  |  |  | Number of Pay Periods | Not a Leap Year | 52 |  |  |  | Number of Pay Periods | Leap Year | 27 |  |  |  | Number of Pay Periods |  | 26 |  |  |  | Number of Pay Periods |  | 12 |  |  |  |  | Number of Pay Periods |  | 12 |  |  |  |  | Number of Pay Periods |  | 24
Pay Periods | Start Date | DOW | End Date | DOW |  | Pay Periods | Begin Date | Day of the week | End Date | Day of the week |  | Pay Periods | Begin Date | Day of the week | End Date | Day of the week |  | Pay Periods | Begin Date | Day of the week | End Date | Day of the week |  | Pay Periods | Begin Date | Day of the week | End Date | Day of the week | Paydate |  | Pay Periods | Begin Date | Day of the week | End Date | Day of the week | Paydate |  | Pay Periods | Begin Date | End Date | Paydate
1 |  |  |  |  |  | 1 | 2023-01-01 00:00:00 |  | 2023-01-07 00:00:00 |  |  | 26 | 2020-12-13 00:00:00 | Sunday | 2020-12-26 00:00:00 | Saturday |  | 1 | 2022-12-19 00:00:00 | Monday | 2023-01-01 00:00:00 | Sunday |  | 7 | 2022-07-01 00:00:00 | Friday | 2022-07-31 00:00:00 | Sunday | Friday, July 29, 2022 |  | 1 | 2021-01-01 00:00:00 | Friday | 2021-01-31 00:00:00 | Sunday | Friday, January 29, 2021 |  | 1 | 2023-01-01 00:00:00 | 2023-01-15 00:00:00 | 2023-01-13 00:00:00
2 |  |  |  |  |  | 2 | 2023-01-08 00:00:00 |  | 2023-01-14 00:00:00 |  |  | 1 | 2020-12-27 00:00:00 | Sunday | 2021-01-09 00:00:00 | Saturday |  | 2 | 2023-01-02 00:00:00 | Monday | 2023-01-15 00:00:00 | Sunday |  | 8 | 2022-08-01 00:00:00 | Monday | 2022-08-31 00:00:00 | Wednesday | Wednesday, August 31, 2022 |  | 2 | 2021-02-01 00:00:00 | Monday | 2021-02-28 00:00:00 | Sunday | Friday, February 26, 2021 |  | 2 | 2023-01-16 00:00:00 | 2023-01-31 00:00:00 | 2023-01-31 00:00:00
3 |  |  |  |  |  | 3 | 2023-01-15 00:00:00 |  | 2023-01-21 00:00:00 |  |  | 2 | 2021-01-10 00:00:00 | Sunday | 2021-01-23 00:00:00 | Saturday |  | 3 | 2023-01-16 00:00:00 | Monday | 2023-01-29 00:00:00 | Sunday |  | 9 | 2022-09-01 00:00:00 | Thursday | 2022-09-30 00:00:00 | Friday | Friday, September 30, 2022 |  | 3 | 2021-03-01 00:00:00 | Monday | 2021-03-31 00:00:00 | Wednesday | Wednesday, March 31, 2021 |  | 3 | 2023-02-01 00:00:00 | 2023-02-15 00:00:00 | 2023-02-15 00:00:00
4 |  |  |  |  |  | 4 | 2023-01-22 00:00:00 |  | 2023-01-28 00:00:00 |  |  | 3 | 2021-01-24 00:00:00 | Sunday | 2021-02-06 00:00:00 | Saturday |  | 4 | 2023-01-30 00:00:00 | Monday | 2023-02-12 00:00:00 | Sunday |  | 10 | 2022-10-01 00:00:00 | Saturday | 2022-10-31 00:00:00 | Monday | Monday, October 31, 2022 |  | 4 | 2021-04-01 00:00:00 | Thursday | 2021-04-30 00:00:00 | Friday | Friday, April 30, 2021 |  | 4 | 2023-02-16 00:00:00 | 2023-02-28 00:00:00 | 2023-02-28 00:00:00
5 |  |  |  |  |  | 5 | 2023-01-29 00:00:00 |  | 2023-02-04 00:00:00 |  |  | 4 | 2021-02-07 00:00:00 | Sunday | 2021-02-20 00:00:00 | Saturday |  | 5 | 2023-02-13 00:00:00 | Monday | 2023-02-26 00:00:00 | Sunday |  | 11 | 2022-11-01 00:00:00 | Tuesday | 2022-11-30 00:00:00 | Wednesday | Wednesday, November 30, 2022 |  | 5 | 2021-05-01 00:00:00 | Saturday | 2021-05-31 00:00:00 | Monday | Monday, May 31, 2021 |  | 5 | 2023-03-01 00:00:00 | 2023-03-15 00:00:00 | 2023-03-15 00:00:00
6 |  |  |  |  |  | 6 | 2023-02-05 00:00:00 |  | 2023-02-11 00:00:00 |  |  | 5 | 2021-02-21 00:00:00 | Sunday | 2021-03-06 00:00:00 | Saturday |  | 6 | 2023-02-27 00:00:00 | Monday | 2023-03-12 00:00:00 | Sunday |  | 12 | 2022-12-01 00:00:00 | Thursday | 2022-12-31 00:00:00 | Saturday | Friday, December 30, 2022 |  | 8 | 2021-08-01 00:00:00 | Sunday | 2021-08-31 00:00:00 | Tuesday | Tuesday, August 31, 2021 |  | 6 | 2023-03-16 00:00:00 | 2023-03-31 00:00:00 | 2023-03-31 00:00:00
7 |  |  |  |  |  | 7 | 2023-02-12 00:00:00 |  | 2023-02-18 00:00:00 |  |  | 6 | 2021-03-07 00:00:00 | Sunday | 2021-03-20 00:00:00 | Saturday |  | 7 | 2023-03-13 00:00:00 | Monday | 2023-03-26 00:00:00 | Sunday |  | 1 | 2023-01-01 00:00:00 | Sunday | 2023-01-31 00:00:00 | Tuesday | Tuesday, January 31, 2023 |  | 9 | 2021-09-01 00:00:00 | Wednesday | 2021-09-30 00:00:00 | Thursday | Thursday, September 30, 2021 |  | 7 | 2023-04-01 00:00:00 | 2023-04-15 00:00:00 | 2023-04-14 00:00:00
8 |  |  |  |  |  | 8 | 2023-02-19 00:00:00 |  | 2023-02-25 00:00:00 |  |  | 7 | 2021-03-21 00:00:00 | Sunday | 2021-04-03 00:00:00 | Saturday |  | 8 | 2023-03-27 00:00:00 | Monday | 2023-04-09 00:00:00 | Sunday |  | 2 | 2023-02-01 00:00:00 | Wednesday | 2023-02-28 00:00:00 | Tuesday | Tuesday, February 28, 2023 |  | 10 | 2021-10-01 00:00:00 | Friday | 2021-10-31 00:00:00 | Sunday | Friday, October 29, 2021 |  | 8 | 2023-04-16 00:00:00 | 2023-04-30 00:00:00 | 2023-04-28 00:00:00
9 |  |  |  |  |  | 9 | 2023-02-26 00:00:00 |  | 2023-03-04 00:00:00 |  |  | 8 | 2021-04-04 00:00:00 | Sunday | 2021-04-17 00:00:00 | Saturday |  | 9 | 2023-04-10 00:00:00 | Monday | 2023-04-23 00:00:00 | Sunday |  | 3 | 2023-03-01 00:00:00 | Wednesday | 2023-03-31 00:00:00 | Friday | Friday, March 31, 2023 |  | 11 | 2021-11-01 00:00:00 | Monday | 2021-11-30 00:00:00 | Tuesday | Tuesday, November 30, 2021 |  | 9 | 2023-05-01 00:00:00 | 2023-05-15 00:00:00 | 2023-05-15 00:00:00
10 |  |  |  |  |  | 10 | 2023-03-05 00:00:00 |  | 2023-03-11 00:00:00 |  |  | 9 | 2021-04-18 00:00:00 | Sunday | 2021-05-01 00:00:00 | Saturday |  | 10 | 2023-04-24 00:00:00 | Monday | 2023-05-07 00:00:00 | Sunday |  | 4 | 2023-04-01 00:00:00 | Saturday | 2023-04-30 00:00:00 | Sunday | Friday, April 28, 2023 |  | 12 | 2021-12-01 00:00:00 | Wednesday | 2021-12-31 00:00:00 | Friday | Wednesday, December 29, 2021 |  | 10 | 2023-05-16 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00
11 |  |  |  |  |  | 11 | 2023-03-12 00:00:00 |  | 2023-03-18 00:00:00 |  |  | 10 | 2021-05-02 00:00:00 | Sunday | 2021-05-15 00:00:00 | Saturday |  | 11 | 2023-05-08 00:00:00 | Monday | 2023-05-21 00:00:00 | Sunday |  | 5 | 2023-05-01 00:00:00 | Monday | 2023-05-31 00:00:00 | Wednesday | Wednesday, May 31, 2023 |  | 1 | 2022-01-01 00:00:00 | Saturday | 2022-01-31 00:00:00 | Monday | Monday, January 31, 2022 |  | 11 | 2023-06-01 00:00:00 | 2023-06-15 00:00:00 | 2023-06-15 00:00:00
12 |  |  |  |  |  | 12 | 2023-03-19 00:00:00 |  | 2023-03-25 00:00:00 |  |  | 11 | 2021-05-16 00:00:00 | Sunday | 2021-05-29 00:00:00 | Saturday |  | 12 | 2023-05-22 00:00:00 | Monday | 2023-06-04 00:00:00 | Sunday |  | 6 | 2023-06-01 00:00:00 | Thursday | 2023-06-30 00:00:00 | Friday | Friday, June 30, 2023 |  | 2 | 2022-02-01 00:00:00 | Tuesday | 2022-02-28 00:00:00 | Monday | Monday, February 28, 2022 |  | 12 | 2023-06-16 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00
13 |  |  |  |  |  | 13 | 2023-03-26 00:00:00 |  | 2023-04-01 00:00:00 |  |  | 12 | 2021-05-30 00:00:00 | Sunday | 2021-06-12 00:00:00 | Saturday |  | 13 | 2023-06-05 00:00:00 | Monday | 2023-06-18 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 3 | 2022-03-01 00:00:00 | Tuesday | 2022-03-31 00:00:00 | Thursday | Thursday, March 31, 2022 |  | 13 | 2023-07-01 00:00:00 | 2023-07-15 00:00:00 | 2023-07-14 00:00:00
14 |  |  |  |  |  | 14 | 2023-04-02 00:00:00 |  | 2023-04-08 00:00:00 |  |  | 13 | 2021-06-13 00:00:00 | Sunday | 2021-06-26 00:00:00 | Saturday |  | 14 | 2023-06-19 00:00:00 | Monday | 2023-07-02 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 4 | 2022-04-01 00:00:00 | Friday | 2022-04-30 00:00:00 | Saturday | Friday, April 29, 2022 |  | 14 | 2023-07-16 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00
15 |  |  |  |  |  | 15 | 2023-04-09 00:00:00 |  | 2023-04-15 00:00:00 |  |  | 14 | 2021-06-27 00:00:00 | Sunday | 2021-07-10 00:00:00 | Saturday |  | 15 | 2023-07-03 00:00:00 | Monday | 2023-07-16 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 5 | 2022-05-01 00:00:00 | Sunday | 2022-05-31 00:00:00 | Tuesday | Tuesday, May 31, 2022 |  | 15 | 2023-08-01 00:00:00 | 2023-08-15 00:00:00 | 2023-08-15 00:00:00
16 |  |  |  |  |  | 16 | 2023-04-16 00:00:00 |  | 2023-04-22 00:00:00 |  |  | 15 | 2021-07-11 00:00:00 | Sunday | 2021-07-24 00:00:00 | Saturday |  | 16 | 2023-07-17 00:00:00 | Monday | 2023-07-30 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 8 | 2022-08-01 00:00:00 | Monday | 2022-08-31 00:00:00 | Wednesday | Wednesday, August 31, 2022 |  | 16 | 2023-08-16 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00
17 |  |  |  |  |  | 17 | 2023-04-23 00:00:00 |  | 2023-04-29 00:00:00 |  |  | 16 | 2021-07-25 00:00:00 | Sunday | 2021-08-07 00:00:00 | Saturday |  | 17 | 2023-07-31 00:00:00 | Monday | 2023-08-13 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 9 | 2022-09-01 00:00:00 | Thursday | 2022-09-30 00:00:00 | Friday | Friday, September 30, 2022 |  | 17 | 2023-09-01 00:00:00 | 2023-09-15 00:00:00 | 2023-09-15 00:00:00
18 |  |  |  |  |  | 18 | 2023-04-30 00:00:00 |  | 2023-05-06 00:00:00 |  |  | 17 | 2021-08-08 00:00:00 | Sunday | 2021-08-21 00:00:00 | Saturday |  | 18 | 2023-08-14 00:00:00 | Monday | 2023-08-27 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 10 | 2022-10-01 00:00:00 | Saturday | 2022-10-31 00:00:00 | Monday | Monday, October 31, 2022 |  | 22 | 2023-09-16 00:00:00 | 2023-09-30 00:00:00 | 2023-09-29 00:00:00
19 |  |  |  |  |  | 19 | 2023-05-07 00:00:00 |  | 2023-05-13 00:00:00 |  |  | 18 | 2021-08-22 00:00:00 | Sunday | 2021-09-04 00:00:00 | Saturday |  | 19 | 2023-08-28 00:00:00 | Monday | 2023-09-10 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 11 | 2022-11-01 00:00:00 | Tuesday | 2022-11-30 00:00:00 | Wednesday | Wednesday, November 30, 2022 |  | 22 | 2023-10-01 00:00:00 | 2023-10-15 00:00:00 | 2023-10-13 00:00:00
20 |  |  |  |  |  | 20 | 2023-05-14 00:00:00 |  | 2023-05-20 00:00:00 |  |  | 19 | 2021-09-05 00:00:00 | Sunday | 2021-09-18 00:00:00 | Saturday |  | 20 | 2023-09-11 00:00:00 | Monday | 2023-09-24 00:00:00 | Sunday |  |  |  |  |  |  |  |  | 12 | 2022-12-01 00:00:00 | Thursday | 2022-12-31 00:00:00 | Saturday | Friday, December 30, 2022 |  | 22 | 2023-10-16 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00
21 |  |  |  |  |  | 21 | 2023-05-21 00:00:00 |  | 2023-05-27 00:00:00 |  |  | 20 | 2021-09-19 00:00:00 | Sunday | 2021-10-02 00:00:00 | Saturday |  | 21 | 2023-09-25 00:00:00 | Monday | 2023-10-08 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 2023-11-01 00:00:00 | 2023-11-15 00:00:00 | 2023-11-15 00:00:00
22 |  |  |  |  |  | 22 | 2023-05-28 00:00:00 |  | 2023-06-03 00:00:00 |  |  | 21 | 2021-10-03 00:00:00 | Sunday | 2021-10-16 00:00:00 | Saturday |  | 22 | 2023-10-09 00:00:00 | Monday | 2023-10-22 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | 2023-11-16 00:00:00 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00
23 |  |  |  |  |  | 23 | 2023-06-04 00:00:00 |  | 2023-06-10 00:00:00 |  |  | 22 | 2021-10-17 00:00:00 | Sunday | 2021-10-30 00:00:00 | Saturday |  | 23 | 2023-10-23 00:00:00 | Monday | 2023-11-05 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 2023-12-01 00:00:00 | 2023-12-15 00:00:00 | 2023-12-15 00:00:00
24 |  |  |  |  |  | 24 | 2023-06-11 00:00:00 |  | 2023-06-17 00:00:00 |  |  | 23 | 2021-10-31 00:00:00 | Sunday | 2021-11-13 00:00:00 | Saturday |  | 24 | 2023-11-06 00:00:00 | Monday | 2023-11-19 00:00:00 | Sunday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 2023-12-16 00:00:00 | 2023-12-31 00:00:00 | 12/20/23*
25 |  |  |  |  |  | 25 | 2023-06-18 00:00:00 |  | 2023-06-24 00:00:00 |  |  | 24 | 2021-11-14 00:00:00 | Sunday | 2021-11-27 00:00:00 | Saturday |  | 25 | 2023-11-20 00:00:00 | Monday | 2023-12-03 00:00:00 | Sunday
26 |  |  |  |  |  | 26 | 2023-06-25 00:00:00 |  | 2023-07-01 00:00:00 |  |  | 25 | 2021-11-28 00:00:00 | Sunday | 2021-12-11 00:00:00 | Saturday |  | 26 | 2023-12-04 00:00:00 | Monday | 2023-12-17 00:00:00 | Sunday
27 |  |  |  |  |  | 27 | 2023-07-02 00:00:00 |  | 2023-07-08 00:00:00 |  |  | 26 | 2021-12-12 00:00:00 | Sunday | 2021-12-25 00:00:00 | Saturday
28 |  |  |  |  |  | 28 | 2023-07-09 00:00:00 |  | 2023-07-15 00:00:00
29 |  |  |  |  |  | 29 | 2023-07-16 00:00:00 |  | 2023-07-22 00:00:00
30 |  |  |  |  |  | 30 | 2023-07-23 00:00:00 |  | 2023-07-29 00:00:00
31 |  |  |  |  |  | 31 | 2023-07-30 00:00:00 |  | 2023-08-05 00:00:00
32 |  |  |  |  |  | 32 | 2023-08-06 00:00:00 |  | 2023-08-12 00:00:00
33 |  |  |  |  |  | 33 | 2023-08-13 00:00:00 |  | 2023-08-19 00:00:00
34 |  |  |  |  |  | 34 | 2023-08-20 00:00:00 |  | 2023-08-26 00:00:00
35 |  |  |  |  |  | 35 | 2023-08-27 00:00:00 |  | 2023-09-02 00:00:00
36 |  |  |  |  |  | 36 | 2023-09-03 00:00:00 |  | 2023-09-09 00:00:00
37 |  |  |  |  |  | 37 | 2023-09-10 00:00:00 |  | 2023-09-16 00:00:00 |  |  | n column H1 (Start Date) and H2 (End Date), the start date and end date are manually entered.
38 |  |  |  |  |  | 38 | 2023-09-17 00:00:00 |  | 2023-09-23 00:00:00 |  |  | H3: this is a drop down list to select the Pay Frequency
39 |  |  |  |  |  | 39 | 2023-09-24 00:00:00 |  | 2023-09-30 00:00:00 |  |  | Cell I4: Looking for a formula here to show the number of pay periods
40 |  |  |  |  |  | 40 | 2023-10-01 00:00:00 |  | 2023-10-07 00:00:00 |  |  | G7:G59: Looking for a formula to show pay periods from G7:G59. Pay period numbers is based on end date and start date
41 |  |  |  |  |  | 41 | 2023-10-08 00:00:00 |  | 2023-10-14 00:00:00 |  |  | H7:H59: Looking for formula to show Begin Date from H7 to H59 based on the Pay Frequency selected in H3 (dropdown selection)
42 |  |  |  |  |  | 42 | 2023-10-15 00:00:00 |  | 2023-10-21 00:00:00 |  |  | J7:J59: Looking for formula to show End Date from J7 to J59 based on the Pay Frequency selected in H3 (dropdown selection)
43 |  |  |  |  |  | 43 | 2023-10-22 00:00:00 |  | 2023-10-28 00:00:00
44 |  |  |  |  |  | 44 | 2023-10-29 00:00:00 |  | 2023-11-04 00:00:00 |  |  | See tables created based on the drop down selection in cell H3
45 |  |  |  |  |  | 45 | 2023-11-05 00:00:00 |  | 2023-11-11 00:00:00 |  |  | Column M to Q (Weekly sample)
46 |  |  |  |  |  | 46 | 2023-11-12 00:00:00 |  | 2023-11-18 00:00:00 |  |  | Column S to W (Bi-weekly sample)
47 |  |  |  |  |  | 47 | 2023-11-19 00:00:00 |  | 2023-11-25 00:00:00 |  |  | Column Y to AD (Monthly sample)
48 |  |  |  |  |  | 48 | 2023-11-26 00:00:00 |  | 2023-12-02 00:00:00 |  |  | Column AM to AP (Semimonthly sample)
49 |  |  |  |  |  | 49 | 2023-12-03 00:00:00 |  | 2023-12-09 00:00:00
50 |  |  |  |  |  | 50 | 2023-12-10 00:00:00 |  | 2023-12-16 00:00:00
51 |  |  |  |  |  | 51 | 2023-12-17 00:00:00 |  | 2023-12-23 00:00:00
52 |  |  |  |  |  | 52 | 2023-12-24 00:00:00 |  | 2023-12-30 00:00:00
 |  |  |  |  |  | 53