With hire date in A1 try this

=IF(A1="","",VLOOKUP(DATEDIF(A1,TODAY(),"y"),{0,0; 1,40;3,80;10,120},2))


try with some test hire dates in A to see if it's what you want


--
Regards,

Peo Sjoblom


"Sharon" wrote in message
...
I have been trying to figure out a formula that will calculate current
vacation hours according to a person's hire date. I have it partly figured
out, but not exactly. I have tried the IF A1 which is my Current Date less
B1
which is my hire date is <365, "0.00", etc. The vacation hrs. are earned
based on 1-2 yrs. = 40 hrs., after 3 yrs.-9yrs. = 80 hrs., after 10yrs.
120
hrs. Does anyone have a formula that will correctly calculate this by hire
date so that the vacation hours do not show until the person's hire date
has
passed? Thanks for ANY Help I can get
--
Any Suggestions Will Be Greatly Appreciated