Date calc

[Enoch11]

I have a list of holiday dates in a column in a worksheet.
I also have a start date and an end date.

I need to check whether any of the holiday dates fall in the range between start date and end date.

Can someone guide me pls?

Tnx.

[Bob Phillips]

=SUMPRODUCT(--(start_date<=holiday_list),--(end_date>=holiday_list))>0