Two Dates are within a month

[_eNVy_]

I need to identify whether two dates (Start and End) fall within any months from 01 April 2021 to 30 September 2022

Some of the End Dates are blank which shows that particular record is still active.

Example
Just a small look into the columns.
Apologies, don't know how to increase the number of columns in the below table. Also added a quick picture of what I want the results to look like.

Start Date	End Date	Apr 21	May 21	Jun 21	Jul 21	Aug 21	Sep 21	Oct 21	Nov 21
05/10/2020	05/10/2021	1	1	1	1	1	1	1	0

The above shows that because the record was active between 05/10/2020 and 05/10/2021 that the months Apr 21 to Oct 21 will show a 1 and months after will be a 0.

If the above's End Date was blank, then months after Oct 21 will also be 1.

Hope this makes sense.

 

[ExceLoki]

this should work for you. i extended it to the end of 2022
-------------

if Two Dates are within a month.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	start date	end date	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22
2	7/28/2021	8/24/2021	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
3	1/20/2021		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
4	4/6/2020		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
5	10/5/2020	12/5/2021	1	1	1	1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0
6	12/6/2021		0	0	0	0	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1
7	9/7/2020		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
8	4/8/2013		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
9	3/1/2021	4/11/2021	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
10	4/11/2021		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
11	4/3/2021	5/13/2021	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
C2:W11	C2	=IF(OR(AND(C$1>=$A2,C$1<=IF($B2="",MAX(TODAY(),C$1),$B2)),AND(DATE(YEAR(C$1),MONTH(C$1)+1,DAY(C$1)-1)>=$A2,C$1<=IF($B2="",MAX(TODAY(),C$1),$B2))),1,0)

 

[_eNVy_]

this should work for you. i extended it to the end of 2022
-------------

if Two Dates are within a month.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	start date	end date	Apr-21	May-21	Jun-21	Jul-21	Aug-21	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22
2	7/28/2021	8/24/2021	0	0	0	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
3	1/20/2021		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
4	4/6/2020		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
5	10/5/2020	12/5/2021	1	1	1	1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0
6	12/6/2021		0	0	0	0	0	0	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1
7	9/7/2020		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
8	4/8/2013		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
9	3/1/2021	4/11/2021	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
10	4/11/2021		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
11	4/3/2021	5/13/2021	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Sheet1

Cell Formulas
Range	Formula
C2:W11	C2	=IF(OR(AND(C$1>=$A2,C$1<=IF($B2="",MAX(TODAY(),C$1),$B2)),AND(DATE(YEAR(C$1),MONTH(C$1)+1,DAY(C$1)-1)>=$A2,C$1<=IF($B2="",MAX(TODAY(),C$1),$B2))),1,0)

Thank you very much! This worked a treat!

 

[ExceLoki]

glad to help.