Date Range within a Date Range

[Susannah68]

I'm trying to find a formula which will identify a date range within a data range. My example is trying to identify whether the date range in columns A and B contains the date range in B2:C2. ie do the dates in columns A & B contain any part of 2021
Apologies if the solution is out there, but I've tried various formulas and none seem to work right. I've included an example where the start date and end date both fall outside of 2021.

Thank you

 

[JamesCanale]

MrExcelPlayground6.xlsx
	A	B	C
1		Start	End
2		1/1/2021	12/31/2021
3
4	Start	End	Yes/No
5	1/1/2022	12/31/2022	No
6	10/1/2021	11/30/2021	Yes
7	6/30/2018	11/30/2022	Yes
8	7/1/2016	6/30/2017	No
9	10/1/2021	11/30/2021	Yes
Sheet8

Cell Formulas
Range	Formula
C5:C9	C5	=IF(AND($B$2<=B5,$C$2>=A5),"Yes","No")

 

[Susannah68]

Great thank you! That worked. I was getting my end and start dates the wrong way round in my formula