It does give you vacation earned by the year which is how you presented it,
nowhere in your original post do you say that you want vacation based on
months

My formula will give you 40 hours if it is between 1 and 3 years, between 3
and 10 years it will give you 80 hours and after 10 years 120 hours. It does
calculate by the actual hire date and it will return 0 until after 1 yes,
and then it will change after each range of years as stated in your
original post


--
Regards,

Peo Sjoblom


"Sharon" wrote in message
...
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