| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prorated vacation formula required
Appreciate the calculation for vacation accural
Vacation is prorated. Less than 5 years of service entitled to 15 days (1.25 days per month) 5-10 years of service entitled to 20 days (1.67 days per month) 10+ years of service entitled to 23 days (1.92 days per month) Date is cell B4 Result in B5 Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vacation Accrual formula | Excel Worksheet Functions | |||
| xirr prorated? | Excel Worksheet Functions | |||
| Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
| Vacation Accrual Formula | Excel Worksheet Functions | |||
Threaded Mode
