how to filter dates?
 

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

"abigail" wrote in message
...
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?

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



"Bill Ridgeway" wrote in message
...
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

"abigail" wrote in message
...
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?