+ Reply to Thread
Results 1 to 2 of 2

holiday calender and days remaining calculator

  1. #1
    Registered User
    Join Date
    06-08-2015
    Location
    lincolnshire
    MS-Off Ver
    2007
    Posts
    1

    holiday calender and days remaining calculator

    Hi i'm completely new to this but have dabbled with excel a little. I have created a holiday chart using excel 2007. We have 10 employees and I have put a second chart at the bottom of the calender to track holidays used and remaining. Then I thought how usefull would it be to have it automated so as when I type a colleagues name in on the holiday calender the remaing holidays would automatically update in the individuals holiday remaining chart. Is this possible or not and if so where would I find some clues to the formula. I would really appreciate any advice. Hello to all on the forum by the way.2016 calender.xlsx
    Last edited by bigrog; 06-10-2015 at 02:17 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: holiday calender and days remaining calculator

    I would recommend a much simpler database-style layout. Instead of a huge scrolling calendar, a simple table where you enter date/name/day-type.

    Then a summary table can be used to provide:
    1) names for the entry table
    2) day-types for the entry table

    I've created a named range called NAMES on sheet2 that includes ALL the name you add to column I, and that is used to create a drop down in column B.

    Check it out. Add some lines and the summary updates in realtime.

    If more days are USED that are given, a red flag will appear in column K.
    Attached Files Attached Files
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. excel formula: days remaining=end date-todays date+extention days
    By fsprings in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-04-2013, 06:45 AM
  2. Show how many days holiday
    By Newtransistorhero in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 11-23-2009, 12:05 PM
  3. Replies: 9
    Last Post: 09-03-2007, 08:26 PM
  4. [SOLVED] Please Help With Days Elapsed And Days Remaining Calculation
    By Scoooter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2006, 12:15 PM
  5. Excel Holiday Roster Calender
    By ksp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2005, 10:35 PM

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