+ Reply to Thread
Results 1 to 2 of 2

Making a Vacation tracker

  1. #1
    Registered User
    Join Date
    11-30-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    1

    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
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,077

    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.
    https://www.excelforum.com/excel-pro...-calendar.html
    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

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