Monthly Payroll Schedule

Robert Wyatt

Board Regular
Joined
Jul 15, 2012
Messages
113
Office Version
  1. 2019
Platform
  1. Windows
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.
 
Hi! Specifically for your case
Cell Formulas
RangeFormula
A1A1=DATE(2025,1,1)
B1:AE1,B7:AE7,B4:AB4B1=A1+1
A2:AE2A2=IF(A1=DATE(2025,1,17),"salary","")
A4A4=DATE(2025,2,1)
A5:AB5A5=IF(A4=DATE(2025,2,17),"salary","")
A7A7=DATE(2025,3,1)
A8:AE8A8=IF(A7=DATE(2025,3,17),"salary","")
 
Upvote 0
This isn't quite what I looking for. See below something like this is what I need.
Pay Period NumberPay Period BeginningPay Period EndingPay Date
111/30/202412/17/202401/17/2025
2
 
Upvote 0
This is what you are looking for?
Book1
ABCD
21Pay Period NumberPay Period BeginningPay Period EndingPay Date
22130.11.202417.12.202417.01.2025
23225.02.202501.03.202517.04.2025
Sheet1
Cell Formulas
RangeFormula
D22:D23D22=EOMONTH(C22,0)+17
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top