T
trucker
I need to set up a spreadsheet that shows the employee name, date of hire,
anniversary date and vacation accrual rate per week.
The accrual rates are as follows:
Anniversary Date
Days Accrued for year 1,2,3,4,5
Year one-5days
Year two-5 days
Year three-5 days
Year Four-10days
Year Five-10 days
Year 9 & On-15 days
0.0192@40HRS A WEEK=0.76 WEEK
0.0384@40 HRS A WEEK=1.53 WEEK
0.0576@40 HRS A WEEK=2.30 WEEK
Any help would be appreciated very much! I'm still in the dark when it comes
to making up formulas.
Thank You!
Lisa
anniversary date and vacation accrual rate per week.
The accrual rates are as follows:
Anniversary Date
Days Accrued for year 1,2,3,4,5
Year one-5days
Year two-5 days
Year three-5 days
Year Four-10days
Year Five-10 days
Year 9 & On-15 days
0.0192@40HRS A WEEK=0.76 WEEK
0.0384@40 HRS A WEEK=1.53 WEEK
0.0576@40 HRS A WEEK=2.30 WEEK
Any help would be appreciated very much! I'm still in the dark when it comes
to making up formulas.
Thank You!
Lisa