Results 1 to 9 of 9

Help need Formula to calculate vacation days left based on anniversary date.

Threaded View

  1. #1
    Registered User
    Join Date
    05-15-2015
    Location
    Clemmons, NC
    MS-Off Ver
    2010
    Posts
    8

    Unhappy Help need Formula to calculate vacation days left based on anniversary date.

    My employer is changing from anniversary date to calendar year effective January 2016. I am having problems getting the formula to come out correctly. I want to use there anniversary date in 2014 to 2015 when it starts over. and then as of July 1 2015 to see how much they would have for the year until Dec 2015. also need to add days already use between the 2014 and 2015 time frame

    example

    my anniversary turns over 3/15/15

    hire date 3/3/2014

    0-2 years 10days
    3-14years 15 days
    15 or more 20 days
    Last edited by yreynolds; 06-24-2015 at 03:02 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 06-04-2013, 12:14 PM
  2. Replies: 2
    Last Post: 02-24-2012, 12:36 PM
  3. Replies: 1
    Last Post: 03-31-2011, 05:03 PM
  4. Accrued Vacation Time based on Anniversary Date
    By Mustang03 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2010, 02:41 PM
  5. Formula for Vacation Accrual Days Based on Anniversary Date
    By Mustang03 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-23-2010, 09:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1