Eligible Vacation Days Calculator
=(DATEDIF(DOH,TODAY(),"M")=6)+(DATEDIF(DOH,TODAY( ),"Y")=1)+(DATEDIF(DOH,TODAY(),"Y")=5)+(DATEDIF( DOH,TODAY(),"Y")=10)+(DATEDIF(DOH,TODAY(),"Y")=1 5)
--
__________________________________
HTH
Bob
"tfarley" wrote in message
...
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?
|