Alternative for Filter function in Excel 2016 - Index Match for date ranges

[TruffleOil]

Hi everyone

I have a set of data with different notification dates for several projects (some different projects have the same notification date).
My goal: filter and list all the projects that fall within a certain date range, in this case by month and year. In this example, I want to show the list of all the projects with notification date in November(more or equal to 1stNov and less or equal 30Nov) (even if they have the same date), whenever I change the calendar month or year to that date. If I change it to April 2023, it should show Project C or more if available.

I saw a video that showed the Filter formula which works fine for this, but I have Excel 2016 and it's not available. I tried Index Match but I'm still a newbie and struggling to come up with a formula. Would appreciate if anyone could help with the right formula for this!!

 

[Fluff]

Hi & welcome to MrExcel.
How about in J8 dragged down

=IFERROR(INDEX($G$17:$G$100,AGGREGATE(15,6,(ROW($G$17:$G$100)-ROW($G$17)+1)/($G$17:$G$100>=$J$1)/($G$17:$G$100<=$L$1),ROWS(J$8:J8))),"")

and in L8

=IFERROR(INDEX($A$17:$A$100,AGGREGATE(15,6,(ROW($G$17:$G$100)-ROW($G$17)+1)/($G$17:$G$100>=$J$1)/($G$17:$G$100<=$L$1),ROWS(L$8:L8))),"")

 

[TruffleOil]

Hi & welcome to MrExcel.
How about in J8 dragged down

=IFERROR(INDEX($G$17:$G$100,AGGREGATE(15,6,(ROW($G$17:$G$100)-ROW($G$17)+1)/($G$17:$G$100>=$J$1)/($G$17:$G$100<=$L$1),ROWS(J$8:J8))),"")

and in L8

=IFERROR(INDEX($A$17:$A$100,AGGREGATE(15,6,(ROW($G$17:$G$100)-ROW($G$17)+1)/($G$17:$G$100>=$J$1)/($G$17:$G$100<=$L$1),ROWS(L$8:L8))),"")

wow can't believe it worked!! thank you so much Fluff, cheers!!

 

[Fluff]

You're welcome & thanks for the feedback.