Formula to Fetch data between two dates

[A_SIRAT]

Hi ,

Please help with a formula as explained in the attached sheet.

I am using office 2019.

thank you !

[#2 · Accepted solution]

@A_SIRAT For Excel-2019 you can try below formula-

=IFERROR(INDEX($A$3:$D$15,AGGREGATE(15,6,(ROW($A$3:$A$15)-ROW($A$2))/(($A$3:$A$15>=$L$1)*($A$3:$A$15<=$L$2)),ROW(1:1)),COLUMN(A$1)),"")

[#3]

thank you Harun !