+ Reply to Thread
Results 1 to 3 of 3

Formula to calculate remaining vacation days from total

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    5

    Question Formula to calculate remaining vacation days from total

    My data looks like this:

    1 2 3 4 5 6 7 8 9 10 Allowed V-days Remaining V-days
    Bears, Don X X X X X 10

    What formula can I use under remaining v-days column that will calculate how many days are left?
    The answer here is 5 of course, but I want this to change as I add another X to the column as the employee uses their vacation days.

    I appreciate any help you can give me.

    Thanks.

    Tricia

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Formula to calculate remaining vacation days from total

    hi Tricia. posting a small sample excel file with a few examples would help. from this one example, i would have to guess
    =L2-COUNTA(B2:K2)

    that is with the assumption your first X starts in B2 & the Allowed V-Days is in L2

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    10-22-2012
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Formula to calculate remaining vacation days from total

    Hi,
    Works exactly right!!
    Thank you! Thank you!!

    Tricia

+ 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. Help need Formula to calculate vacation days left based on anniversary date.
    By yreynolds in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-25-2015, 11:57 AM
  2. [SOLVED] Formula to calculate days and hours remaining in SPECIFIC months.
    By jmewebb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-07-2014, 10:17 AM
  3. [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
  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. HELP-Formula needed to Calculate Accrued vacation days
    By mw11083 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-08-2013, 10:47 AM
  6. Running Total of Days Remaining?
    By demonfly100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-11-2012, 09:40 AM
  7. Excel-formula required to calculate number of days remaining
    By sahar_sultana in forum Excel General
    Replies: 10
    Last Post: 04-03-2009, 02:41 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