+ Reply to Thread
Results 1 to 10 of 10

Vacation Entitlement based on full years of service and odd vacation year

Hybrid View

  1. #1
    Registered User
    Join Date
    02-01-2018
    Location
    Ontario, Canada
    MS-Off Ver
    2007
    Posts
    11

    Re: Vacation Entitlement based on full years of service and odd vacation year

    I did some more fiddling and got a little closer. Everything works for the next vacation year (2018-2019), but not if it is the current vacation year (2017-2018). The month accrual seems to not like something. Check out the attached files and see what you think.

    Note: I did a bit of iferror wrapping just to blank out some #VALUE cells on my actual worksheet.
    Attached Files Attached Files
    Last edited by bferd; 02-02-2018 at 03:06 PM. Reason: basic stupidity

+ 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 Time Based on Years of Service and Position
    By MaryGemmer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2017, 04:00 AM
  2. Vacation Accrual based on fiscal year and years served
    By Jennl77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2016, 06:07 PM
  3. MTD vacation accrual formula based on yeras of service
    By lcwarren in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-03-2015, 06:03 PM
  4. Calculate Vacation Allowance based on years of service
    By Sassygirl44 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2015, 03:47 PM
  5. Replies: 3
    Last Post: 10-16-2013, 09:05 PM
  6. Calculating vacation entitlement
    By kmlloyd in forum Excel General
    Replies: 2
    Last Post: 06-23-2010, 02:51 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