adjusting formula get data between two dates

[abdelfattah]

hello i have this formula works based on year, i would amend between two dates the result should be in column e based on column a after writting start date and end date in range e1,g1

1 (1).xlsx
	A	B	C	D	E	F	G
1	student	date		start date		end date
2	student1	2019/01/01
3	student2	2019/03/01			student
4	student3	2019/05/01
5	student4	2019/07/01
6	student5	2019/09/01
7	student1	2019/11/01
8	student2	2020/01/01
9	student3	2020/03/01
10	student4	2020/05/01
11	student5	2020/07/01
12	student11	2020/09/01
13	student12	2020/11/01
14	student13	2021/01/01
15	student14	2021/03/01
16	student15	2021/05/01
17	student16	2021/07/01
18	student17	2021/09/01
19	student18	2021/11/01
20	student19	2022/01/01
21	student20	2022/03/01
22	student21	2022/05/01
23	student22	2022/07/01
24
Sheet1

Cell Formulas
Range	Formula
E4:E24	E4	=IFERROR(INDEX($A$2:$A$170, MATCH(0,COUNTIF($E$3:E3, IF(($E$1=YEAR($B$2:$B$170)), $A$2:$A$170, $E$3)), 0)), "")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Toadstool]

How about
...
=IFERROR(INDEX($A$2:$A$170, MATCH(0,COUNTIF($E$3:E3, $A$2:$A$170)+($B$2:$B$170<$E$1)+($B$2:$B$170>$G$1), 0)), "")
...

@Fluff It's very possible I'm missing something but wouldn't this need to be entered as an array formula using CSE?

 

[Fluff]

Oops, keep forgetting to do that.
@abdelfattah
As mentioned by Toadstool, the formula should be confirmed with Ctrl Shift Enter, not just enter.

 

[abdelfattah]

thanks fluff now it works very well

 

[Fluff]

Glad we could help & thanks for the feedback.