how to filter dates?

[abigail]

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?

 

[Bill Ridgeway]

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

 

[CLR]

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