Thanks so much Mike. I am alittle confused (image that). I see that $F$4 is
the employees date of hire, what is f7? You said date in question, but I
guess I just don't understand.

Thanks so much!!

"Mike H." wrote:

Assuming F4 has your 10/1/08 BD, then this should work:

=INT((F7-$F$4)/(365/12))

F7 has the date in question. The result will return the number of whole
months since the anniversary. And the definition of a whole month is 365/12
or 30.4 days.

"Steve" wrote:

I have read through the past posts and havent found exactly what I am looking
for. I need to have a formula that will tell me how many months an employee
has worked after his anniversary THIS year, up to his anniversary NEXT year.
I am able to make a formula that will calculate for this year, but when the
year changes, it messes up. EX. Ann. date of 10/1/08. On 11/1/08 it should
say "1", on 12/1/08 is should say "2", on 1/1/09 is should say "3", etc....