View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default 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