Date Filter Sort in Excel 2003

[CLMooreJr]

Hey all....I have a client who wants to sort her data according to month, so she can quickly see who has a birthday in January, etc. Here is the spreadsheet layout..

Employee Title Sex Birthdate HireDate
Text Text Text Date Date

Mike Smith CEO M 10/05/1969 01/01/2000

for the life of me, I tried to autofilter and do a custom filter for "contains" or "begins with" 10, or whatever month, but it returns nothing...any suggestions on how to filter out the months she wants?
Thanks!

"The secret of teaching is to appear to have known all your life what you learned this afternoon

 

[xlbo]

read this FAQ: faq68-5827 to understand why it is not working

Please be clear on your requirement:

I have a client who wants to sort her data according to month

any suggestions on how to filter out the months she wants?

which is it - sort or filter - different answers for each

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question