+ Reply to Thread
Results 1 to 2 of 2

Vacation Accrual and Rollover Spreadsheet

  1. #1
    Registered User
    Join Date
    06-28-2016
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    1

    Vacation Accrual and Rollover Spreadsheet

    Hi!

    I'm trying to set an Excel spreadsheet for a small company (~50 employees), but I've been having some trouble.

    1. We are paid bimonthly (15th and last day of the month)
    2. When hired, employee need to complete a full year of work to start accruing vacation days. (If employee is hired on March 15, 2016.. until March 16, 2017 he/she will be able to enjoy paid leave). Here is the table:

    YEARS OF WORK = VACATION DAYS
    1 year = 6 days
    2 years = 8 days
    3 years = 10 days
    4 years = 12 days
    5-9 years = 14 days
    10-14 yeats = 16 days
    15+ years = 18 days

    3. If you generate vacation days, but don't use them in the following year, you have 3 extra months to use them (rollover). If you don't, they cancel out and you are only left with the newly generated vacation days corresponding to hire date.

    Thankyou in advance for your help!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Vacation Accrual and Rollover Spreadsheet

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vacation accrual spreadsheet
    By thesar805 in forum Excel General
    Replies: 7
    Last Post: 09-04-2017, 06:52 PM
  2. Replies: 1
    Last Post: 09-24-2015, 03:22 PM
  3. Replies: 4
    Last Post: 01-20-2015, 11:51 AM
  4. Employee Vacation / Holiday accrual spreadsheet
    By dzidek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2014, 05:35 PM
  5. [SOLVED] Need Simple Vacation Accrual Spreadsheet
    By mrbsbest in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-29-2013, 10:18 PM
  6. Vacation Accrual Linking Spreadsheet Formula
    By RedWings6 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-25-2013, 01:40 PM
  7. Vacation Accrual Spreadsheet
    By jrace in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-16-2013, 05:28 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