Lynn

I think you should either use a pivot table and look at the Grouping
feature (you can group data by month for example), or use a helper
column to identify what month the birthday is in, so that you can use
that to filter on. An example of such a helper would be:

(Assumes birthdates in A col)

=TEXT(A1,"mmmm")

which will return January,February etc. You can then filter on this
column (using Autofilter).

Does this help?

Richard


Lynn wrote:
I have a long list of names with birthdates. When I sort from A to Z it puts
them in ascending date order. How can I find just the birthdates in a given
month, regardless of year?