+ Reply to Thread
Results 1 to 1 of 1

Vacation Accrual - hire date and calendar year

  1. #1
    Registered User
    Join Date
    Chicago, IL
    MS-Off Ver
    Excel 2007

    Vacation Accrual - hire date and calendar year

    Stumbled upon this website, which helped me get going on what I set out to do based on another post, but am a little over my head at this point.

    Our company accrues vacation on a calendar year, with the accrual rate defined by the hire date.

    <1 year= 0 days/year
    >1 year = 5 days/year
    >3 years= 10 days/year
    >10 years= 15 days/year
    >15 years = 20 days/year

    The attached spreadsheet is great for calculating time accrued based on hire date, but I need to take it a step or two further. I would like the accrual to start on the first of the year, but need to account for any accrual rate change on the employee's anniversary date during the year.

    In other words, during a calendar year an employee about to hit their third anniversary would accrue days at the 5 day rate until their anniversary date, at which point going forward they would accrue at 10 days.

    Thanks for any assistance and please let me know if any other information is necessary.

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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