Monthly Payroll Schedule

[Robert Wyatt]

I would like to make up a Monthly payroll schedule for 2025. Time ends on the 17th of each month. and would get paid the following month on the 17th. Could someone please explain to me how I would go by to fix up the payroll schedule.

 

[Sergius]

Hi! Specifically for your case

rotation-schedule (1).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
2																	salary
3
4	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28
5																	salary
6
7	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
8																	salary
Sheet1

Cell Formulas
Range	Formula
A1	A1	=DATE(2025,1,1)
B1:AE1,B7:AE7,B4:AB4	B1	=A1+1
A2:AE2	A2	=IF(A1=DATE(2025,1,17),"salary","")
A4	A4	=DATE(2025,2,1)
A5:AB5	A5	=IF(A4=DATE(2025,2,17),"salary","")
A7	A7	=DATE(2025,3,1)
A8:AE8	A8	=IF(A7=DATE(2025,3,17),"salary","")

 

[Robert Wyatt]

This isn't quite what I looking for. See below something like this is what I need.

Pay Period Number	Pay Period Beginning	Pay Period Ending	Pay Date
1	11/30/2024	12/17/2024	01/17/2025
2

 

[Sergius]

This is what you are looking for?

Book1
	A	B	C	D
21	Pay Period Number	Pay Period Beginning	Pay Period Ending	Pay Date
22	1	30.11.2024	17.12.2024	17.01.2025
23	2	25.02.2025	01.03.2025	17.04.2025
Sheet1

Cell Formulas
Range	Formula
D22:D23	D22	=EOMONTH(C22,0)+17

 

[Robert Wyatt]

I'm not understanding. The job pays once a month on the 17th of each month. that is 12 pay periods to determine the beginning and ending that is what I trying to figure out.
Time goes on the 17th of each month. I need to figure out the Pay period Beginning date and Pay period Ending date.

 

[Sergius]

Your first message has a question about something else.

Time ends on the 17th of each month. and would get paid the following month on the 17th

But is it not in my previous message?
Now you say

I need to figure out the Pay period Beginning date and Pay period Ending date.

So what do you need to get? Show how it is, how it should be. Then it will be easier to help you.

 

[Robert Wyatt]

OK the pay periods have been figured out now I have another question. Sense the pay periods are once a month is their anyway to fix it up to show in cell F9 pay period ending and I9 pay date from the pay period beginning date C9. each time a time sheet is made up. I have tired Index but keep getting n/a. I have tired VLOOKUP, but that doesn't work either. Any help would be appreciated.

 

[Robert Wyatt]

OK the pay periods have been figured out now I have another question. Sense the pay periods are once a month is their anyway to fix it up to show in cell F9 pay period ending and I9 pay date from the pay period beginning date C9. each time a time sheet is made up. I have tired Index but keep getting n/a. I have tired VLOOKUP, but that doesn't work either. Any help would be appreciated.

Please forgive my brainless thought. I have figured it out if you put EOMonth(C9,0)+17 in pay period ending and the same in pay date it works just like it was intended to. thanks again for all the help.