LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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....
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
vacation accrual formula jd_dps Excel Discussion (Misc queries) 3 January 29th 09 08:14 PM
Vacation accrual Spreadsheet TimBeau Excel Discussion (Misc queries) 6 May 28th 08 03:40 PM
Vacation/Sick accrual [email protected] Excel Worksheet Functions 0 February 15th 06 07:43 PM
Please help!! Vacation Accrual Formula MissNadine Excel Worksheet Functions 1 August 19th 05 02:32 AM
Vacation Accrual Formula MissNadine Excel Worksheet Functions 0 August 18th 05 04:02 AM


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"