Results 1 to 7 of 7

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

Threaded View

  1. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,315

    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
    =IFERROR(INDEX('Form responses '!$A$2:$A$4,SMALL(IF(('Form responses '!$C$2:$C$4<=$A2)*('Form responses '!$D$2:$D$4>=$A2)*('Form responses '!$F$1:$L$1=TEXT($A2,"dddd"))*('Form responses '!$F$2:$L$4=""),ROW('Form responses '!$A$2:$A$4)-ROW(INDEX('Form responses '!$A$2:$A$4,1,1))+1),COLUMN(A:A))),"")

    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.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

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