Using Numbers to compare date ranges

Hey everyone,

I am looking for some help in getting numbers to compare date ranges.

I have a list of people with certain time sensitive rules and I would like the sheet to tell me if the date range for said rule overlaps with a particular week of the quarter.

The following screenshot demonstrates the kind of thing I am hoping to make work.

So at the moment I am looking at the week of the 16th to the 22nd of October (Week X). I would like the "Ongoing?" column (E) to simply say "YES" or "NO" if any date between the "Start Date" (C) and "End Date" (D) falls within Week X.

I believe I have been able to find a way of verifying the individual start and end dates relative to Week X with a combination of IF & AND formulas with inequalities and conditional highlighting. This serves as a more specific reminder to ensure the rule has been added or removed as the weeks are being worked on. Finding a way for the document to tell me whether the rule is ongoing or not has proved more difficult and researching hasn't lead to any fruitful solutions other than using Excel.

If there are any ideas out there I'd be all ears, even if it means modifying other parts of the document or changing existing formulas. Please also note that all dates in the screenshot above are DD/MM/YY.

Thanks heaps in advance for any help or suggestions!