filtering dates

[Caroline]

Hi,

I have imported into excel a list of names with their
dates of birth and are trying to filter the list to show
only those who were born in August (any year). I seem to
be unable to do this as the cells are date and not text
fields. Is there a way round this?

Caroline

 

[Bob Phillips]

Add a helper column. If dates in column B, in C1 add
=TEXT(B1,"mmm")

copy down and filter on column C

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Domenic]

Hi Caroline,

One way would be to use Advanced Filter. Assuming that your names are
in Column A, and the date of birth is in Column B, enter the following
formula, somewhere after your table...

let's say:

A14 leave blank
A15 =MONTH(B2)=8

Data > Filter > Advanced Filter
List range: select your range for your list
Criteria: select cells A14 and A15
Click Ok

If you want to copy the filtered list to another location, check "Copy
to another location", and choose your location in the "Copy to" box.

Hope this helps!