Monthly to Cusotm Date Report

Hi Experts,
I hoper every one is well, I have a file which is created report my month but I need it will change from monthle to custome date (example start date 09/13/20 End Date 09/27/20 etc), I'm using formula in A11 ={IF(ROWS(A$11:A11)>$B$2,"",INDEX(Table9[[#All],[Column1]],SMALL(IF(TEXT(Table9[[#All],[Column1]],"yyyymmm")=$A$2&$A$3,ROW(Table9[[#All],[Column1]])-ROW(DataFeeding!$A$4)+1),ROWS(A$11:A11))))}

Thanks in Advance,

Regards,
Aaru

Hi AliGW, I'm using MS Excel 2007

perhaps

=IF(ROWS(A$11:A11)>$C$2,"",INDEX(Table9[[#All],[Column1]],SMALL(IF((Table9[[#All],[Column1]]>=$B$2)*(Table9[[#All],[Column1]]<=$B$3),ROW(Table9[[#All],[Column1]])-ROW(DataFeeding!$A$4)+1),ROWS(A$11:A11))))}

where b2/b3 are Start/End dates, C2 -No of entries

Thanks, John, I have applied but it is not working

I have attached excel file formula is not working

Change C2

=SUMPRODUCT((Table9[[#All],[Column1]]>=$B$2)*(Table9[[#All],[Column1]]<=$B$3))

It does work!

Thanks john, I'm talking about A11 which is an update by month, I want it will update by custom date, I have sent sample file.

I have sent sample file

I KNOW that! If check the formula: it uses C2 which was incorrect. Why do you think I gave you the new formual?

PLEASE test before saying they do not work!

I have tried it is working on C3 but, the below report formulas is showing #num.

ok SIR.........

See attached -not all completed

Thank You John, you are excellent.