View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tfarley tfarley is offline
external usenet poster
 
Posts: 8
Default Eligible Vacation Days Calculator

Need to calculate if someone has worked X months since DOH, they are entitled
to X vacation days: over 6 months = 1 week vacation; over 1 year = 2 weeks;
over 5 years = 3 weeks; over 10 years = 4 weeks; over 15 years = 5 weeks.

D2 E2 F2
Date of Hire Today's Date =DATEDIF($D2,$E2,"m")

Any suggestions?