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?
Bookmarks