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

"abigail" <abigail@discussions.microsoft.com> wrote in message
news:69390A39-14DB-4D7B-B33C-79ABE7ED01E0@microsoft.com...
>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?

[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



"Bill Ridgeway" <info@1001solutions.co.uk> wrote in message
news:ddvvkn$a46$1@newsg2.svr.pol.co.uk...
> 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" <abigail@discussions.microsoft.com> wrote in message
> news:69390A39-14DB-4D7B-B33C-79ABE7ED01E0@microsoft.com...
> >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?
>
>