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
|