I've got 1 Google sheet (called DATA) with 3 columns (Start Date, End Date, Event Name) and then another Google sheet (called SCHEDULE) with 1 column of sequential dates (06/01/2018, 06/02/2018, etc).
You’re going to want to familiarize yourself with Google Apps Script for Sheets. This will provide comfort and familiarity with the object model and how to recourse through ranges. I would probably loop through the Schedule sheet, and for each date in the schedule, loop through the data sheet row by row. For each iteration in the inner loop:
Does that work?