Dynamic table that extracts records that meet 2 criteria (Date Range)

[KevinJA]

Hi,

I am trying to create a dynamic table that extracts records that fall between a certain date range. I am unable to get the list to populate.

My formula is as Follows:
{=IF(ROWS(L$9:L9<=$M$2,INDEX(INDIRECT(L$8),SMALL(IF(Add_time>=$C$3,IF(Add_time<=$D$3, ROW(Owner)-ROW(Formula!E2)+1)),ROWS(L$9:L9))),"")}

I based on this tutorial: https://youtu.be/NbP-dHau9-I

Here is a link to the file:
https://www.dropbox.com/s/s2cmqooa4lny03n/sales stats 6 - clean.xlsm?dl=0

I have identified 2 potential reasons it will not work.
1) The formula requires reference to a cell that says how many records meet the criteria (M2). I can't get this number to populate correctly.
Current Formula: =COUNTIFS (Add_time,">="&C3, Add_time,"<="&D3)
I have also tried:=SUMPRODUCT((Add_time>=C3)*(Add_time<=D3))
but to no avail

2) Formula!E2 above is supposed to indicate where the first record is (i think). It does not appear to be a valid reference though (it is not colored)

These are my best guesses. I am actually trying to do this twice. Once for meetings booked in the last week, the other for all upcoming meetings (these are sales stats from our sales team). For all upcoming meetings i just changed the range to all meetings in the next year)

Appreciate any help you can provide on this. Pulling my hair out right now. THANKS!

Kevin