+ Reply to Thread
Results 1 to 4 of 4

Show event with date range on calendar

  1. #1
    Registered User
    Join Date
    11-16-2017
    Location
    Virginia
    MS-Off Ver
    2016
    Posts
    2

    Show event with date range on calendar

    Hello anyone and everyone - I am new to learning all the stuff that Excel can do (which is way more than I thought). I've tried searching all over for an answer, and have taken pieces from this and that, but I'm missing something and don't know what.

    So, I had a task of making a calendar from a spreadsheet and populating that calendar with the events that are listed with the corresponding dates and date ranges, and some of the dates have multiple events.

    I have the calendar down (it's perpetual if anyone was wondering) and it's working great... but I only have some events appearing. By some I mean that it appears that the first event listed on a date will pop up, and only sometimes will a second event show with the same date - sometimes it's listed as the same event above it, and sometimes it's the same event as a previous day.

    It would be great to have a push/guidance on what I need to clean up to make sure that second and third events posted are what's happening on that day, and also on events that cover a range of days.

    I've attached what I'm working on, and it can probably be seen in the first full week of November 2017 of what I'm saying.

    If this has been answered somewhere else, I apologize and hope someone can point me in the right direction.


    -Whitesell
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,614

    Re: Show event with date range on calendar

    Hi Whitesell. Welcome to the forum.

    If you are not aware of it already the lookup functions find only the first instance of lookup_value it finds in table_array. To return multiple instances you will need an array formula (or maybe helper columns).

    If you arenít familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

    Try array entering this formula in B13 of 'Calendar (2) and fill down to B17. Then fill across to column H. You will have to repeat for each week. Note the absolute row reference for day. It permits copying one formula all referencing the same row#.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Registered User
    Join Date
    11-16-2017
    Location
    Virginia
    MS-Off Ver
    2016
    Posts
    2

    Re: Show event with date range on calendar

    Oh, okay. I knew it was something that I just didn't know.

    I'll go read up on array-entered formulas, so I can at least understand it and not just copy and paste it, because I'm not familiar with them.

    I appreciate the help very much Dave, thanks. I think (hopefully) that this was the guidance I needed.

    -Whitesell

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,614

    Re: Show event with date range on calendar

    Good deal. Encouraging self study is what this forum is about!!

    To aid and abet your efforts ... if you are not already aware of it ... there is a feature called Evaluate formula (Fx). Stepping through a solution using Fx is one of the best devices for trouble shooting formulas and self study. I encourage it's use whenever I can.

    Thank you for the feedback and rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    Dave

+ 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. Show recuurence event in calendar (month view)
    By teireii in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-07-2017, 02:26 AM
  2. [SOLVED] Show or hide Excel calendar rows based on current date
    By Saabra in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-11-2017, 03:12 PM
  3. [SOLVED] Please help - cell needs to show date selected on calendar
    By menolas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2016, 08:07 AM
  4. Macro to trigger, when date becomes current, a calendar event in outlook?
    By HS_ECSE in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2015, 05:25 PM
  5. [SOLVED] Have code for userform calendar but will not show todays date, please help
    By Jeff up North in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2013, 03:05 PM
  6. [SOLVED] Show today's date on calendar
    By Marco-Kun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 04:23 PM
  7. Let calendar show current date
    By jpcsolutions in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2011, 05:28 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