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.
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.
