S
Steve
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....
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....