In F2 =DATEDIF($D2,$E2,"m")/12

In G2 =LOOKUP(F2,{0,0.5,1,5,10,15},{0,1,2,3,4,5})


Gord Dibben MS Excel MVP


On Tue, 24 Jun 2008 12:29:01 -0700, tfarley
wrote:

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?