Excel VBA Tips n Tricks #11 Find the Pay Period Start Date and End Date - Easy!

With this tip, you can type any date and it will return with the start date and the end date of the pay period the date belongs to. Customize it easily!!

Fantastic Developer Tools:

[ExcelVbaIsFun]

Great question Vu Minh Duc Vu! In short, if we wanted Saturday through Saturday (totaling 15 full days), that would be correct, but the initial day mus be accounted for. In this case, we're wanting day 1 plus 13 days = 14 total days, Sat thru Fri, not Sat thru Sat. Consider this chart.
Day 1+0=1, Sat
Day 1+1= 2nd day, Sun
1+2=3, Mon
1+3=4, Tue
1+4=5, Wed
1+5=6, Thu
1+6=7, Fri, this is Sat thru Fri. 7 total days, but must acct for day 1.
So 1+13=14 which in this case is Fri. 1+7=8, day1 again, 1+14 same

[aron]

Dude you are a life saver. I am trying to do a biweekly service schedule and j think I can use this to auto fill my start and end dates based on current date

[krn]

Thanks Daniel. Mike Girvin should like this one. :)

[mohammadafsari]

Hi Thank you , question i have pms file i want to know is there any way to excel calculate by own and find 3rd date between start and finish date with formula and gives best match date between 2 start and finish date, it's example that can expand for 1000 tasks
Thank you 🌹🌹

[jvclfsm]

Hello! My payroll is 1 week off. For example, I was just paid 3/8/2019 and the pay period for it is 2/16/2019 - 3/01/2019. What I need to know is how do I look up the pay period for each pay date? My workbook I've made has 12 sheets for Jan-Dec and I've gone thru and marked each payday, what I'd like to do is mark the pay periods. Can you or anyone help?