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?
|