+ Reply to Thread
Results 1 to 7 of 7

Block booking on a Calendar

  1. #1
    Registered User
    Join Date
    06-09-2020
    Location
    UK
    MS-Off Ver
    2013
    Posts
    15

    Block booking on a Calendar

    Hi all,

    I'm trying to make a calendar in my workplace for Managers to use to keep an eye on staff holidays and important dates (attached).

    The biggest struggle I'm having so far is the vast majority of people will book off a week or two at a time rather than individual days. With the document as it currently stands that means if three people wanted to book a week off at the same time then it would take 21 different lines of data to have the Calendar show that.

    Is there anyway it's possible to put a block set of dates in, for example, 01/01/2021-07/01/2021. So that it only takes up one line, rather than 7? I would still need it to colour code as it currently does.

    Any light anyone can shed would be greatly appreciated.

    I apologise in advance is there is already a thread dedicated to this, but i barely knew how to describe it myself.

    Thanks in advance.
    Dan.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,977

    Re: Block booking on a Calendar

    I have devised calendar files in the past where I have up to 7, or 10, or even more, simultaneous events on any one day, but this obviously calls for a different layout than the type in your file. I generally display a full month (up to 6 weeks, or 5 if "orphan" days are shown in the top row of each month), where each week occupies 8 (or 11) rows, and have a drop-down where the User can select the month (and year), and the display automatically adjusts. Data is taken from a table of "events" (title, date etc.) and placed on the calendar as appropriate. In order to cope with date ranges, another table automatically expands the raw data to have one record per day, and it is this table which supplies the data for the calendar.

    This would look quite different to your file, but I can give you several examples if you wish to pursue this approach further (or you could search the forum for them).

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-09-2020
    Location
    UK
    MS-Off Ver
    2013
    Posts
    15

    Re: Block booking on a Calendar

    Hi Pete,

    Thank you for such a speedy reply.

    It would be great to see some examples of what you mean if you don't mind?

    Thanks for your help.

    Dan

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,977

    Re: Block booking on a Calendar

    OK, I'll get back to you later, probably after MOTD.

    Pete

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,977

    Re: Block booking on a Calendar

    Hi Dan,

    There is a Leave Calendar of mine in this thread from a couple of years ago:

    https://www.excelforum.com/excel-gen...-calendar.html

    See if that is suitable, and get back to me.

    Hope this helps.

    Pete

  6. #6
    Registered User
    Join Date
    06-09-2020
    Location
    UK
    MS-Off Ver
    2013
    Posts
    15

    Re: Block booking on a Calendar

    Hi Pete,

    I think I can make that work, thanks for your help again!

    Dan

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    20,977

    Re: Block booking on a Calendar

    You're welcome, and thanks for the rep.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Pete

+ 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. Booking on date and time in calendar
    By Mikkel_pet in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-26-2019, 06:44 PM
  2. Problem calendar after year change (booking system)
    By malin.astrand in forum Excel General
    Replies: 5
    Last Post: 03-15-2018, 05:16 PM
  3. how to create a booking calendar???
    By ajs100 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-11-2014, 08:34 AM
  4. Creating a booking calendar in Excel using SUMIFS
    By Nick O in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2014, 11:49 PM
  5. Replies: 0
    Last Post: 01-31-2014, 01:09 PM
  6. Hotel Booking Calendar
    By freiheit in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-15-2012, 04:35 PM
  7. Replies: 2
    Last Post: 05-21-2012, 05:19 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