Ok. maybe I'm just being dense but I tried it and it's still not sorting by
month & why would I do it as coloumn when I already have my data in a coloumn
format? ARGGGG Thanks for being patient with me!
--
Naomi


"M Kan" wrote:

Sorry, meant a helper column. This would just be an extra column in Excel
where you calculate the month number.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Naomi" wrote:

What is a helper row????? Thanks!
--
Naomi


"M Kan" wrote:

If all of your data is in Excel, you can add a helper row and use the formula
=Month(ref) to generate a month value (1-12) and then filter on that.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Naomi" wrote:

I work in a medical office and need to do chart review by birth date. How
can I filter my table or a pivot table by date of birth within a month range.
Example: all dates of birth in October, November, December for any year!

PLEASE HELP ME!
--
Naomi