Is a month within a date range

[th081]

HI All,

I have two cells with a start date and end date e.g 01/05/21 to 01/07/21, this range can be small or it can span several years. I have another cell with a month i.e January.

What i would like is a formula that tells me if January (or another month) is within the date range, so for the dates 01/05/21 to 01/07/21 the answer would be no, but if the date range was 01/05/21 to 10/01/22 the answer would be yes as Jan is in the date range.

Can anyone help?

 

[BSALV]

Map1
	A	B	C	D	E
1		start	end
2	period1	1/01/22	31/12/22
3	period2	1/02/22	28/02/22		WAAR
Blad1

Cell Formulas
Range	Formula
E3	E3	=MIN(C2:C3)-MAX(B2:B3)=C3-B3

 

[th081]

thanks BSALV,

My period two is simply January, February etc not a date range, presumably i would have to create a start and end date from January to use if your formula

 

[njimack]

Book1
	A	B	C	D
1	Start	End		January
2	01/05/2021	01/07/2021	FALSE
3	01/05/2021	10/01/2022	TRUE
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=AND(MONTH(A2)>=MONTH(--("01-"&$D$1)),MONTH(B2)<=MONTH(--("01-"&$D$1)))

Note - you should really consider entering an actual date rather than text

 

[th081]

Thanks Neil,

if you put 10/02/22 in B3 its says false. I am going to redesign my spreadsheet to use an actual date