+ Reply to Thread
Results 1 to 5 of 5

Holiday Tracker

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Holiday Tracker

    Hello All,

    I've been searching this forum for many number of years and have always found the help I needed - usually it was because somebody else had the same issue and asked the question and the excel guru's on here answered! So...many thanks for the help that you all have given me (even if you never knew you were helping!)

    Anyway, I have an issue that I can't seem to find an answer to. I'm trying to create a "holiday tracker" spreadsheet. Basically what I would like to do is have a dropdown list with the values "earned" and "used". So when I use a holiday, it subtracts from my total and when I earn a holiday (i.e. work on a Saturday) it adds to my total....so it would be something like this;

    Date Start Date End Type Used / Earned Days Taken / Earned Balance
    Weekend Work Earned 10 10
    Vacation Used 6 4

    So, basically what I'm looking for is what to put in the "balance" column so that if I put a value in the "days taken/earned" column it will add or subtract from my balance based on if I choose "earned" or "used" from my dropdown menu in the "used/earned" column.

    Hope that makes some sense!!

    Cheers!

  2. #2
    Forum Contributor
    Join Date
    02-20-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    170

    Re: Holiday Tracker

    Assuming Date Start is cell A1, enter this into F4 (the next 'Balance' cell after the 4):

    =IF(D4="Earned",F3+E4,IF(D4="Used",F3-E4,""))

  3. #3
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Holiday Tracker

    Hi,

    Is something like this what you're after???

    Hope this helps

  4. #4
    Registered User
    Join Date
    02-25-2014
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Holiday Tracker

    Folks,

    Many thanks! This is exactly what I was trying to do. In the end I used ajryan88's function, but both seemed to work well.

    Thanks again!

  5. #5
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Holiday Tracker

    You're welcome

    Just to let you know, you can thank the people who have helped you by clicking on the * next to their post. This will add to their reputation also

+ 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. Holiday planner/tracker
    By ukphoenix in forum Excel General
    Replies: 6
    Last Post: 04-16-2012, 07:37 AM
  2. Holiday Leave Tracker Help
    By subtilty in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2011, 10:39 AM
  3. Holiday Tracker
    By Benjamin2008 in forum Excel General
    Replies: 4
    Last Post: 02-06-2010, 08:38 AM
  4. Employee Holiday Tracker
    By Benjamin2008 in forum Excel General
    Replies: 4
    Last Post: 02-05-2010, 11:07 AM
  5. holiday tracker
    By vikfowler in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2008, 06:27 AM

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