Array formula to list data if MONTH and DAY fall between two dates

[SevenOut]

I have a workbook with two worksheets.
Sheet1 has a beginning date in D3 and an ending date in J3. (Schedule starting with Sat and ending with Fri).
Sheet2 has a list of birthdates. NAMES are A3:A47 and BIRTHDATES are B3:B47

So, my previous experience I've managed to work an array formula that would list the names and dates of birthdays for the current month. I'm having difficulty however adjusting the formula to find the names/dates if the month and day of Sheet2!B3:B47 fall between Sheet1!D3 and Sheet1!J3.

=IFERROR(INDEX($A$3:$A$47,SMALL(IF(MONTH($B$3:$B$47)=MONTH(Sheet1!$D$3),ROW($A$3:$A$47)-ROW($A$3)+1),ROWS($1:1))),"")

This formula for example, will only return data for the month of date in Sheet1!D3.

I do hope my explanation is clear, an example sheet can be worked up if needed.

 

[Scott T]

Try

Book1
	D	E	F	G	H	I	J
3	2/1/2020						2/7/2020
4
5
6		name7
7
8
9
10
11
12
13
14
15
16
17
Sheet1

Cell Formulas
Range	Formula
E6:E17	E6	{=IF(ROWS(E$6:E6)>SUMPRODUCT(($D$3<=Sheet2!$B$3:$B$47)*(Sheet1!J3>=Sheet2!B3:B47)),"",INDEX(Sheet2!$A$3:$A$47,SMALL(IF(Sheet2!$B$3:$B$47>=Sheet1!$D$3,IF(Sheet2!$B$3:$B$47<=Sheet1!$J$3,ROW(Sheet2!$A$3:$A$47)-ROW(Sheet2!$A$3)+1)),ROWS(E$6:E6))))}
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[SevenOut]

Here is an example of what I have:
Workbook.xlsx

 

[SevenOut]

Scott T, thank you for the response. The formula does not provide a result however. There should be two Names returned.

 

[sandy666]

with data from post#3 only Name2 meets the conditions

 

[SevenOut]

The workbook provided, there are two birthdays on 2/5 (Feb 5th) which fall between dates 2/1 and 2/7. The formula provides zero returns however. I will upload a version with the formulas added, perhaps I've done something wrong

 

[SevenOut]

Here is what I have so far:
Workbook2.xlsx

 

[sandy666]

schedule: February
Birthdays: only one February is there

if you want compare Months and Days - result will be Nothing (0)
and I am not saying about formula

@post#7
what's the differences with post#3 ?

 

[Scott T]

Try
using 2/15-2/21 as the date range

Book1
	A	B	C	D	E	F
2	Name	Date			Name	Date
3	name1	1/1/1997			name7	2/17/1995
4	name2	1/2/1950			name17	2/20/1970
5	name3	3/5/1970			name23	2/16/1980
6	name4	11/20/1980
7	name5	6/10/1960
8	name6	2/2/1980
9	name7	2/17/1995
10	name8	9/22/1970
11	name9	6/9/1966
12	name10	7/7/1977
13	name11	9/1/1997
14	name12	2/28/1980
15	name13	5/2/1976
16	name14	12/20/1976
17	name15	11/27/1974
18	name16	7/21/1973
19	name17	2/20/1970
20	name18	2/8/1975
21	name19	1/30/1973
22	name20	5/3/1978
23	name21	3/21/1974
24	name22	10/12/1977
25	name23	2/16/1980
26	name24	6/1/1977
27	name25	8/25/1979
28	name26	4/9/1973
29	name27	5/27/1974
30	name28	6/13/1970
31	name29	2/3/1974
32	name30	3/15/1974
33	name31	8/6/1970
34	name32	10/29/1973
35	name33	12/14/1977
36	name34	4/24/1974
37	name35	3/25/1978
38	name36	3/2/1975
39	name37	2/7/1994
40	name38	1/30/1988
41	name39	7/9/1979
42	name40	12/4/1991
43	name41	9/30/1977
44	name42	1/30/1975
45	name43	7/7/1999
46	name44	5/5/1966
47	name45	4/4/1969
Sheet2

Cell Formulas
Range	Formula
E3:E16	E3	{=IF(ROWS(E$3:E3)>SUMPRODUCT((DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))>=Sheet1!$D$3)*(DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))<=Sheet1!$J$3)),"",INDEX($A$3:$A$47,SMALL(IF(DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))>=Sheet1!$D$3,IF(DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))<=Sheet1!$J$3,ROW(Sheet2!$A$3:$A$47)-ROW(Sheet2!$A$3)+1)),ROWS(E$3:E3))))}
F3:F16	F3	{=IF(ROWS(E$3:E3)>SUMPRODUCT((DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))>=Sheet1!$D$3)*(DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))<=Sheet1!$J$3)),"",INDEX($B$3:$B$47,SMALL(IF(DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))>=Sheet1!$D$3,IF(DATE(YEAR(TODAY()),MONTH($B$3:$B$47),DAY($B$3:$B$47))<=Sheet1!$J$3,ROW(Sheet2!$A$3:$A$47)-ROW(Sheet2!$A$3)+1)),ROWS(E$3:E3))))}
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[SevenOut]

There are two Feb. Birthdates, 2/5/74 and 2/5/65 (Name7 and Name8) 1/2/1950 is Jan 2nd.
Scott T, I'll try again this evening