In Sheet 1, I have column A with an event’s Start date and column B with the event’s End date.

In Sheet 2, column A has a formula that gives me the coming Saturday’s date:

=TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>5,11,5)

Column B gives me the coming Sunday’s date:

=TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>5,11,6)

I need to have a cell TRUE in Sheet 1 if the event is happening during the coming weekend.

I have no idea how to do this…

Thanks!!