Show data with month criteria drop list (dynamic)

If you select row 12 and apply auto-filters, you can use the in built functionality to filter by month.

If you want to do it with formula, you cannot do this in the same place (in the same sheet) where data reside.

See in attachment how it can be achieved in separate sheet. There is start of period in B1:
='report of'!N5
(in real life you would like to have a dropdown list probably in this new sheet - may be directly in this cell)

end of period in C1:
=DATE(YEAR(B1),MONTH(B1)+1,0)

in cells B2 and C2 I look for rownumber where dates for selected month reside
=MATCH(B1-0.5,'report of'!B:B,1)+1
and
=MATCH(C1+0.5,'report of'!B:B,1)

having this prepared displaying only data from these rows is as easy as:
=IF(ROW(A1)>$C$2-$B$2+1,"",OFFSET('report of'!A$1,$B$2+ROW(A1)-2,0))
(and copy right as needed and down with some rows).

Of course format as you need.

Hi John,

Here a solution with filtering in the same sheet.

There is formula in in column AA and filter applied in row 12
I had to relocate your data validation list to sheet1 and added SUBTOTAL function instead of SUM. This will show you amount only for the visible cell.

What you need to do is to select month from drop-down menu and click 'Reapply' button locate under Data tab.

Thanks John for the feedback!