+ Reply to Thread
Results 1 to 2 of 2

Vacation Accrual

  1. #1
    Registered User
    Join Date
    11-07-2008
    Location
    Massachusetts
    Posts
    4

    Vacation Accrual

    I use Excel 2000 and need some help creating a spreadsheet that will calculate accrued vacation time daily based on date of hire as well as time taken and balance remaining. I have searched the previous posts, but have not found one that suits the criteria that we need.

    We have approximately 45-50 employees and the weekly accrual rates are:

    One week for first year (.769)
    Two weeks for years 2-5 (1.538)
    Three weeks for years 5+ (2.307)

    Iíve started (& attached) what I think would be a good way to track this, but donít know how to write the formulas to calculate the values we need. Any help would be greatly appreciated because Iím ready to pull my hair out! Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    re: Vacation Accrual

    I modified your file to show you a possible solution.

    I highligted all the cells that I changed.

    Note the current accrual rate is not used in any formula, it's just for information only.
    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)

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