+ Reply to Thread
Results 1 to 8 of 8

Formula for vacation days earned annualy with additional days at a milestone

  1. #1
    Registered User
    Join Date
    06-24-2015
    Location
    United States
    MS-Off Ver
    Latest
    Posts
    3

    Formula for vacation days earned annualy with additional days at a milestone

    I currently need help calculating a formula which will generate the number of vacation days earned under the following conditions:
    • 10 days for each year of service beginning on the one year anniversary of service
    • 15 days for each year of service beginning on the 10 year anniversary of service

    The table currently includes (in this order) employee name, date of hire, current date, years worked (I have already developed a formula for the years worked), days earned, days used, current balance. I simply need to create a formula for the days earned column which will automatically update along with my current formula in order to calculate days earned with the given information.

    Thanks!

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,890

    Re: Formula for vacation days earned annualy with additional days at a milestone

    It would probably help if you can post a desensitized version of the worksheet? Seeing the formula you already have for years worked may help in developing a "days earned" formula that has continuity.

  3. #3
    Registered User
    Join Date
    06-05-2015
    Location
    Manchester, UK
    MS-Off Ver
    2016
    Posts
    93

    Re: Formula for vacation days earned annualy with additional days at a milestone

    I'm a little confused. Do you mean that you accrue 10 days holiday each year for the first 10 years of service?

    So once you've completed about 28 years of service you never have to come to work again?

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,890

    Re: Formula for vacation days earned annualy with additional days at a milestone

    I think, because the employer I used to work for used the same wording, that it means for years two through ten you are allowed 10 paid vacation days per year. Starting with year eleven you get 15 vacation days per year. I can relate to the second part of your post however, because after thirty-five years I do not have to go to work (for them) again.

  5. #5
    Registered User
    Join Date
    06-05-2015
    Location
    Manchester, UK
    MS-Off Ver
    2016
    Posts
    93

    Re: Formula for vacation days earned annualy with additional days at a milestone

    10 days paid holiday per year

  6. #6
    Registered User
    Join Date
    06-26-2015
    Location
    Canada
    MS-Off Ver
    Office 360
    Posts
    2

    Re: Formula for vacation days earned annualy with additional days at a milestone

    I'm also looking for something similar. Should I make a separate post or can I latch to this one?

  7. #7
    Registered User
    Join Date
    06-24-2015
    Location
    United States
    MS-Off Ver
    Latest
    Posts
    3

    Re: Formula for vacation days earned annualy with additional days at a milestone

    Quote Originally Posted by JeteMc View Post
    It would probably help if you can post a desensitized version of the worksheet? Seeing the formula you already have for years worked may help in developing a "days earned" formula that has continuity.
    Here is a version of the spreadsheet with the names edited out:
    https://www.dropbox.com/s/tf6faj1nh0...s%29.xlsx?dl=0

  8. #8
    Registered User
    Join Date
    06-24-2015
    Location
    United States
    MS-Off Ver
    Latest
    Posts
    3

    Re: Formula for vacation days earned annualy with additional days at a milestone

    Quote Originally Posted by JeteMc View Post
    I think, because the employer I used to work for used the same wording, that it means for years two through ten you are allowed 10 paid vacation days per year. Starting with year eleven you get 15 vacation days per year. I can relate to the second part of your post however, because after thirty-five years I do not have to go to work (for them) again.
    Yes, you are correct. I am just an intern here; however, employees here earn ten days each year beginning on the one year anniversary of their employment. After 15 years, employees begin to gain 15 vacation days a year.

+ 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. Work Schedule that calculates hours, lunches, days off and vacation days
    By tameronstarr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 12:06 PM
  2. [SOLVED] Need help with a formula to calculate vacation days please!
    By hisbutterfly in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-08-2013, 06:23 AM
  3. Formula for Vacation Days when eligible
    By tastjuste in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2013, 08:11 PM
  4. Calculate vacation days taken or partial days
    By chris1965 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 07:18 PM
  5. Vacation Days Taken vs Vacation Days Scheduled
    By Gtrtim112 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2013, 02:44 PM

Tags for this Thread

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