Excel auto filtering to find a range of dates in a list
It might be easier to use a helper column (i.e. another column next to
your data in which you can add a formula). I would suggest a formula
such as:
=MONTH(A2)
assuming your dates start in A2. Copy the formula down, and use this
column to filter looking for months (obviously, February is 2).
Hope this helps.
Pete
|