Results 1 to 7 of 7

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

Threaded View

  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.

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