how to filter dates?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to filter out a number of date groups from a large data base. I
have not had much luck using advanced filter with wildcards. how do I go
about filtering aout certain months from a large range of years?
 
One way would need a helper column with the formula -

=month(A1)

This will return the month number from the target cell and sorting on the
helper column will bring all the entries together by month.

Regards.

Bill Ridgeway
Computer Solutions
 
Yup, and with Bill's suggestion of the helper column, you can also use the
AutoFilter on it if you wish to actually filter-out all the unwanted
dates..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top