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?

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.

If I understand correctly then the following array entered formula displays what you want:

Formula:

=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.