View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Vacation Accrual

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