+ Reply to Thread
Results 1 to 2 of 2

Making a Vacation tracker

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Making a Vacation tracker

    I am trying to make a tracker for approved vacation. Currently I send out a request to my team they go thru and request their dates and then I give a yes or no type answer. once i approve it then that subtracts the numbers of day from how many days they have for the year vacation. Now i am needing to make sure i have 4 people on vacation per week for all 52 weeks. which would be easy if i required my people to take their vacation in full weeks but i don't want to have to do that. i would like to allow them to have say Thursday and Friday off. Then i would need to track the remaining days of that week so that i can ensure that i have 4 people off per week. I added a year calendar to another sheet and would like that when i click approve that it would also add a count to that day so when it it 4 people off for that day it will turn red. Or at least something that i can check at a quick glance. Also would be able to see at a quick glance home many more people i need to get to that 4 mark. i have attached a sample of what i already have. i did reduce the number of employees on my sample but normally i would have 60 total. Any help on this would be amazing thank you.
    Attached Files Attached Files

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

    Re: Making a Vacation tracker

    Hello SmoothDawg and Welcome to Excel Forum.
    Is your team playing for the SEC championship this weekend?
    I am not a calendar expert, however I feel that the layout of the data in the file attached to post #1 is going to be difficult to work with.
    Take a look at the file attached to post #7 of the thread linked below and see if, with modification, it would be acceptable for your purposes.
    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 Tracker for 9/80 and 4/10 Workers
    By SuperGeek58 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-05-2021, 08:02 AM
  2. 2020 Vacation Tracker
    By Philipsfn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-09-2020, 09:59 AM
  3. Seniority Vacation Tracker and Calendar
    By rjerand in forum Excel General
    Replies: 6
    Last Post: 10-18-2019, 08:04 AM
  4. [SOLVED] Need to create a vacation tracker for 350+ employees
    By bethnee641 in forum Excel General
    Replies: 11
    Last Post: 11-12-2018, 01:53 AM
  5. Vacation Accrued/Used tracker sheet
    By busymom78 in forum Excel General
    Replies: 1
    Last Post: 06-18-2014, 04:52 AM
  6. Re: Date Vacation Tracker
    By tls in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2006, 08:45 PM
  7. Looking for a vacation tracker
    By GeorgieP in forum Excel General
    Replies: 0
    Last Post: 07-21-2005, 02:05 PM


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