+ Reply to Thread
Results 1 to 1 of 1

Excel 2008 : Help with vacation accrual

  1. #1
    Registered User
    Join Date
    03-27-2012
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help with vacation accrual

    This is a new system this year (2012) in our company for vacation: Our employees accrue vacation on their anniversary date based on tenure (7.5 hours up to 4 years, 11.25 hours up to 8 years, and 15 hours for all others). They accrue for only 10 months to get all available time; no vacation rolls over. Right now, all employees hired before December 31, 2011, have an anniversary date of January 1. All employees hired this year and moving forward have their hire date as an anniversary date. I have a spreadsheet that calculates accrued hours based on calculating the month we're in. However, I don't know how to account for no accrual in November and December. Neither do I know how to set up formulas for people whose anniversary is anything other than January 1. Can anyone help?
    Attached Files Attached Files
    Last edited by LSporte; 03-27-2012 at 02:44 PM. Reason: adding attachment

+ 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