Confirming a certain month is within a date range

[workinonexcel]

I need a formula that will confirm if a given month falls within a date range.

For example, Column A has the beginning of the date range, 2/1/21. Column B has the end of the range, 6/30/21. I then have a column for each month of the year, Column C is January, Column D is February, etc.

From there, I need to return "Yes" or "No" confirming whether that month is included in the date range, across the columns, for each month. If the initial date starts mid-month, that month should be "No". This is not an issue on the end date.

Thanks in advance for your help!

 

[kweaver]

Welcome to Mr. Excel.

By "mid-month" do you mean the 15th?

Something like this?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Begin	End	January	February	March	April	May	June	July	August	September	October	November	December
2	2/1/2021	6/30/2021	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
3	2/15/2021	8/10/2021	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
4	3/10/2021	5/20/2021	No	No	Yes	Yes	Yes	No	No	No	No	No	No	No
5	4/20/2021	5/15/2021	No	No	No	No	Yes	No	No	No	No	No	No	No
Names

Cell Formulas
Range	Formula
C2:N5	C2	=IF(AND($A2<DATE(YEAR($A2),MONTH(DATEVALUE(C$1&"1")),15),MONTH($A2)<=MONTH(DATEVALUE(C$1&"1")),MONTH($B2)>=MONTH(DATEVALUE(C$1&"1"))),"Yes","No")

 

[Peter_SSs]

Welcome to the MrExcel board!

Could this be what you want?

21 12 15.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Begin	End	January	February	March	April	May	June	July	August	September	October	November	December
2	1/02/2021	30/06/2021	No	Yes	Yes	Yes	Yes	Yes	No	No	No	No	No	No
3	15/02/2021	10/08/2021	No	No	Yes	Yes	Yes	Yes	Yes	Yes	No	No	No	No
4	10/03/2021	20/05/2021	No	No	No	Yes	Yes	No	No	No	No	No	No	No
5	20/04/2021	15/05/2021	No	No	No	No	Yes	No	No	No	No	No	No	No
In month

Cell Formulas
Range	Formula
C2:N5	C2	=LET(cd,DATEVALUE(1&C$1),IF(cd=MEDIAN(cd,$A2,$B2),"Yes","No"))

 

[kweaver]

Peter: I think if the OP is talking about the 15th of the month, then your row 4 should be OK for March, yes/no?

 

[Peter_SSs]

Peter: I think if the OP is talking about the 15th of the month,

I thought the OP meant anything after the first of the month so wrote my formula for that.

 

[workinonexcel]

Thank you so much, I will try these today and see what works. By mid-month, I meant any day after the first of the month! Thank you both,