This is my first time posting but I have looked and looked and I'm now pulling my hair out. I need a
spreadsheet to calculate vacation accruals based on hire date. I would like columns that include hire date, today's date,
hours accrued. As some employees will only take 1/2 days off, I would like the pay period columns to work with numbers = 4
instead of X's. Here are our parameters:
26 Pay Periods - need the sheet to be based on pay periods
90 Days till vacation accrual begins
1-3 years = 3.0769 / pay period (10 days per year)
4-9 years = 4.6154 / pay period
10-14 years = 5.8462 / pay period
15 years = 6.9231 / pay period
Max is at 180 hours or 22.5 days per year.
I have a formula from someone else's sheet that I have tried to modify
but I can't figure out where to change the pay periods which I would change before I modified the hours (at the end of the
formula.) I am attaching the sheet - please look at the formulas in column F and I.
I sure do appreciate any help
you guru's can give me!!!