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
Bookmarks