View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cdsgidget cdsgidget is offline
external usenet poster
 
Posts: 9
Default 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