Thanks for the suggestion. I tried this, but it still only gives me the
vacation earned by the year, I need to have it calculate it by the actual
hire date. I need a formula that would also use the month and date so that
the vacation does not appear available until the person's hire date
anniversary. It has been a challenge trying to figure this one out.

--
Any Suggestions Will Be Greatly Appreciated


"Peo Sjoblom" wrote:

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