How can I filter the data to be filtered with the filters cells?

Please be aware that data in column AA has 10k rows.

CodePudding user response：

Try this:

=FILTER(AA:AA, MATCH(AA:AA, Y2:Y3,0))

That should filter the dates matching the 2 cells that you want.

CodePudding user response：

The filter command does a good job.

=FILTER(AA5:AA,AA5:AA >= Y1, AA5:AA <= Y2)

Here are the docs for it, honestly it is my favorite formula.