PTO Schedule

mchri233

New Member
Joined
Oct 23, 2019
Messages
3
Hello,

I am trying to create a PPTo accrual schedule based on a few parameters:
- EEs begin with 1 of 3 PTO categories/days: 15, 20, or 25 days,
- At the EEs Anniversary date (of Employment), the begin accruing an additional PTO day, with Anniversary PTO days capped at 5 days
- Maximum PTO is capped at 25 days, Regular and Anniversary included - meaning, those beginning with 25 days do not accrue Anniversary.

I had in mind to have a schedule that, based on the end-of-month (EOM) date, the cell will produce the monthly hourly accrual for that month, and/or if that EE's anniversary is in that month, the cell will populate with their "new" monthly accrual.

i find myself going down rabbet holes b/w/n ifs, index(match),datedifs, so on and so forth.

Any assistance is greatly appreciated.
 

Attachments

  • PTO Temp (MrExcel).PNG
    PTO Temp (MrExcel).PNG
    26.3 KB · Views: 11

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,129,483
Messages
5,636,601
Members
416,927
Latest member
BNM8V6

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
Top