Forum Discussion
A_SIRAT
Aug 16, 2022Iron Contributor
Formula to Fetch data between two dates
Hi ,
Please help with a formula as explained in the attached sheet.
I am using office 2019.
thank you !
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)),"")
2 Replies
Sort By