Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vacation Accrual Formula Need Help Please!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculation vacation accrual? | Excel Worksheet Functions | |||
Vacation Accrual formula | Excel Worksheet Functions | |||
Vacation/Sick accrual | Excel Worksheet Functions | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions |