Finished Date Range Formulas in Search Sheet

Hello,

On my Search sheet in column C an 'X' is placed to search by criteria. Notice it pulls all the matches for the Part Number from the hidden sheet AFRsDB.

What I would like to do is pull the data for the Finished Date but within the date range in D13:D14. Does anyone have any ideas how to do this please?

Thank you,
Fred

In cell E3, Array-Enter (enter using Ctrl-Shift-Enter)

=IFERROR(IF($C$7="X",SMALL(IF(AFRsDB!$AF$2:$AF$25889>=$D$13,IF(AFRsDB!$AF$2:$AF$25889<=$D$14,ROW(AFRsDB!$AF$2:$AF$25889))),ROW(A1)),SMALL(IF(INDEX(AFRsDB!$C$2:$AN$25889,,$D$2)=VLOOKUP("X",$C$4:$D$7,2,FALSE),ROW(AFRsDB!$C$2:$AN$25889)),ROW(A1))),"")

And then copy down.