+ Reply to Thread
Results 1 to 2 of 2

Vacation Accrual Spreadsheet Tracker

  1. #1
    Registered User
    Join Date
    Chicago, Illinois
    MS-Off Ver
    MS Office Home and Business 2016

    Exclamation Vacation Accrual Spreadsheet Tracker


    I need help building a vacation tracker for my company. i have created a spreadsheet with all the columns i need. now i need the columns to read from each other. if that makes any sense.

    Here is the vacation policy

    0-2 years of service- accrue .77 weekly
    3-4 years of service- accrue 1.54 weekly
    5+ years of service- accrue 2.31 weekly

    We are allowed 40 hours rollover.

    I need the following to reflect:
    Column B to read to Column C & D & E- the start will reflect the correct amounts
    Column F will be put in by myself
    Column F needs to read to column T - (Added in to balance)
    Column G-R needs to read to Column S
    Column S needs to be subtracted from Column T
    Column S needs to have the yearly allotment & rollover amount

    I hope that makes sense

    Please help!

    I have attached the spreadsheet with the columns
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    MS-Off Ver
    Excel 2010/2019

    Re: Vacation Accrual Spreadsheet Tracker

    Hello melissap21 and Welcome to Excel Forum. In the attached copy of the file:
    Column C is populated using: =DATEDIF(B2,TODAY(),"y")
    Column D is populated using: =INDEX(W$2:W$4,MATCH(C2,V$2:V$4))
    Note that the formula for column D index's values from a range that is added to the original setup.
    Column E is populated using: =D2*52
    Column S is populated using: =SUM(G2:R2)
    Column T is populated using: =SUM(E2:F2)-S2
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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 kaalab in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-09-2018, 01:09 PM
  2. Vacation accrual spreadsheet
    By thesar805 in forum Excel General
    Replies: 7
    Last Post: 09-04-2017, 06:52 PM
  3. Accrual Vacation Spreadsheet
    By kfos in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-29-2016, 10:36 AM
  4. Vacation Accrual and Rollover Spreadsheet
    By garzalore in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2016, 06:02 PM
  5. Replies: 1
    Last Post: 09-24-2015, 03:22 PM
  6. Replies: 4
    Last Post: 01-20-2015, 11:51 AM
  7. Vacation Accrual Spreadsheet
    By jrace in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-16-2013, 05:28 PM

Tags for this Thread


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