+ Reply to Thread
Results 1 to 2 of 2

Accrued Vacation Time based on Anniversary Date

  1. #1
    Registered User
    Join Date
    05-22-2010
    Location
    United States, PA
    MS-Off Ver
    Excel 2003
    Posts
    7

    Talking Accrued Vacation Time based on Anniversary Date

    Hello,

    I am creating a vacation accrual spreadsheet and I need assistance in the cells highlighted in green. The vacation accrual should reset itself automatically when the employee's anniversary date rolls around. The frequency of the accrual should be daily.

    I have 2 different tabs. One for hourly employees and the other for salary. Both should work the same, with the exception of the amount of vacation time alotted hr. vs. salary.

    I have the spreadsheet attached. I would like to only manually populate the cells highlighted in yellow and have the green ones automatically calculate.

    Can you please help me to create the cells highlighted in green?

    Thank you,
    Attached Files Attached Files
    Last edited by Mustang03; 05-24-2010 at 06:11 PM.

  2. #2
    Forum Contributor
    Join Date
    08-11-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    149

    Re: Accrued Vacation Time based on Anniversary Date

    I only did it for one tab but it's easy enough to copy the tab and change the numbers.

    I added a row and a column to your table so I can do a vlookup to get the right number of days for the number of years. I then did some basic date math to figure the number of days since the last anniversary and multiply by vacation days / 365.

    Oh and I changed the formula in column C because your method gets a minor error over time due to leap years.
    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