Look up across columns by Date Range and Return multiple matches

Hi all! I am stumped on how to write an array to return a list of matches.

sheet1 A1 is Headers D1-M1 Generated Dates from Original Date + Interval
A1client (header) B1 interval (header) C1 original Date D1 Date E1 Date 1 F1 Date 2 and so on thru M1
A2client a 14 1/1/2020 1/15/2020 1/29/2020 2/12/2020
A3client b 28 1/1/2019 1/29/2019 2/26/2019 3/02/2019
A2client c 14 1/1/2020 1/15/2020 1/29/2020 2/12/2020
A3client d 28 1/1/2019 1/29/2019 2/26/2019 3/02/2019
A2client e 14 1/1/2020 1/15/2020 1/29/2020 2/12/2020
A3client f 28 1/1/2019 1/29/2019 2/26/2019 3/02/2019



I want to return a client list where the match is on a start date and end date range specified on sheet 2
A1 Start Date B1 End Date
1/15/2020 1/30/2020


List Returned:
client a 14
client c 14
client e 14

=iferror(index($a$1:$a$7,aggregate(15,6,row($a$2:$a$7)/(($c$2:$l$7>=$c$9)*(mod(column($c$2:$l$7),2)=1))/(($d$2:$m$7<=$d$9)*(mod(column($d$2:$m$7),2)=0)),rows($a$9:a9))),"")

Thanks for responding Tim!

I'm not seeing any results when I pasted this formula. Any chance you can use my spreadsheet attached and send back?

Best,
Amanda

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$7)/(MOD(COLUMN($C$2:$L$7),2)=1)/(($C$2:$L$7+$B$2:$B$7>$D$9)*$D$9+($C$2:$L$7+$B$2:$B$7)*($C$2:$L$7+$B$2:$B$7<=$D$9)-($C$2:$L$7>$C$9)*$C$2:$L$7-($C$2:$L$7<=$C$9)*$C$9>0),ROWS($A$9:A9))),"")
the above formula takes into acount part range crosses

btw AGGREGATE doesn't work with IF