+ Reply to Thread
Results 1 to 7 of 7

Return events that take place on date based on list of events with date ranges

  1. #1
    Registered User
    Join Date
    11-26-2016
    Location
    Antwerp
    MS-Off Ver
    10
    Posts
    6

    Return events that take place on date based on list of events with date ranges

    Hi all,

    I have a sheet with a list of events that take place during a certain date range, some only take place only on certain days.

    For this I have a sheet that looks like this:

    Event title, start date, end date, monday, tuesday, wednesday, thursday, friday, saturday
    example1, 1/01/2018, 5/02/2018, no, no, yes, no, no, no, no
    example2, ....

    On a different tab I have a sheet that looks like this

    Date Event 1, Event 2, Event 3,...
    1/01/2018
    2/01/2018
    ....

    Does anyone have a way to return the events that take place like this?
    Attached Files Attached Files
    Last edited by nickpauwels; 04-28-2018 at 07:07 AM.

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

    Re: Return events that take place on date based on list of events with date ranges

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as it doesn't work on this forum.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    11-26-2016
    Location
    Antwerp
    MS-Off Ver
    10
    Posts
    6

    Re: Return events that take place on date based on list of events with date ranges

    Added, thanks for the help.

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

    Re: Return events that take place on date based on list of events with date ranges

    If you have restricted availability, as in your first record, is it only likely to be for one day a week, or could it be for two or three days?

    Do you want to include Saturdays and Sundays of they occur within the date span?

    Pete

  5. #5
    Registered User
    Join Date
    11-26-2016
    Location
    Antwerp
    MS-Off Ver
    10
    Posts
    6

    Re: Return events that take place on date based on list of events with date ranges

    It can be for several days, so people could even exclude just one or two days. That way people could choose to fill in the entire week but exclude weekends.
    If nothing is specified, it should be for the entire week, including weekends.
    Last edited by nickpauwels; 04-29-2018 at 05:31 AM.

  6. #6
    Registered User
    Join Date
    11-26-2016
    Location
    Antwerp
    MS-Off Ver
    10
    Posts
    6

    Re: Return events that take place on date based on list of events with date ranges

    For part 1 of the problem I figured out the following solution:
    Please Login or Register  to view this content.
    Anyone have an idea on how to add the "only on days" part of the problem?

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Return events that take place on date based on list of events with date ranges

    If I understand correctly then the following array entered formula displays what you want:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Note that only non event days are identified on the Form Responses sheet.
    I am not sure how this translates into Google Docs, I would suspect that placing the ArrayFormula function in front would work.
    Let us know if you have any questions.
    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. [SOLVED] Calculate future date based on dates of past events.
    By DEPEWMCDOG in forum Excel General
    Replies: 7
    Last Post: 12-15-2017, 06:30 PM
  2. Replies: 1
    Last Post: 08-04-2016, 01:33 AM
  3. [SOLVED] Counting events in a date table over 24 hours based on a condition.....
    By sambashir in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-08-2013, 06:04 AM
  4. Need help counting events within a certain date ranges
    By i.suck.at.excell in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-25-2012, 11:32 PM
  5. Replies: 6
    Last Post: 11-03-2012, 04:29 AM
  6. Date & time input interface and show upcoming events based on urgency
    By Alheksi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2010, 08:26 AM
  7. List of dates and events - returning only the last date for a particular event
    By Rapa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2007, 10:24 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