Dynamic "Filter by Condition" in Pivot

Question

i have a pivot table often required to adjust date range which up to 6 different dates from column A1 to A6. What kind of formula should i use in the "Filter By Condition" > "Custom Formula" based on the date references in A1:A6 so that i don't have to go to filter and select and deselect the date whenever i need the data? Appreciate your help here.

Updated: Google Sheet Trix here

Answer 1

Use this formula to filter data based on the dates that you need and then construct a pivot table from there:

=FILTER(A2:F, MATCH(A2:A, N2:N7,0))

Note: N2:N7 is the range of the dates that you want to filter. You may need to edit that range based on where you have that data.

The best way I found to achieve what you're looking for was filtering data first, then create a pivot table on the results.