You have several options....

Here's one:

With
A5:A100 contains names, with A1: Name
B5:B100 contains birthdates, with B1: Birthdate

Then..try this
A1: Jan
B1: MonthTest (or Blank or any other text that is NOT a column heading)
B2: =TEXT(B6,"mmm")=$A$1

Select A5:B100
Then....From the Excel main menu:
<data<filter<advanced filter
List Range: $A$5:$B$100
Criteria Range: $B$1:$B$2
Click the [OK] button

Only names with Birthdays in January will be visible.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"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?