I am trying to work out the following problem where:

Cell A1 = Date
Column B= Event Name
Column C= Start Date
Column D = End date
Cell E1 = answer

I am trying to write a formula without macros where the Date in cell A1 can be found within the range of column C and Column D and return the corresponding B (event name or names) in E1

A simple if statement below works for 1 cell in B, C & D but not when trying to search the entire column. When I try to do that I get a Value error