Finding people born in a given month or after a given year

I have a spreadsheet that contains peoples names and birthdates as follows:

John 3/17/75
Jane 5/1/55
etc.

I would like to do two things.

First, I would like to extract all the people who were born in a given
month, say March, and display their names and birthdates separately. (Could
they be displayed in a separate worksheet?)

Second, I would like to display the names and birthdates of all the people
who were after a given year, e.g., 1985.

Any help would be appreciated,
Howard

Hi Watercolor artist

With this add-in it is very easy to do
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Watercolor artist" <Watercolorartist@discussions.microsoft.com> wrote in message
news:B62CE14F-5647-49DF-9399-C51282061671@microsoft.com...
>I have a spreadsheet that contains peoples names and birthdates as follows:
>
> John 3/17/75
> Jane 5/1/55
> etc.
>
> I would like to do two things.
>
> First, I would like to extract all the people who were born in a given
> month, say March, and display their names and birthdates separately. (Could
> they be displayed in a separate worksheet?)
>
> Second, I would like to display the names and birthdates of all the people
> who were after a given year, e.g., 1985.
>
> Any help would be appreciated,
> Howard