Another option is to install EasyFilter
http://www.rondebruin.nl/easyfilter.htm

You can do it without the helper column then



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
I'd use another column of cells with formulas like:

=text(a2,"mmmm")

And filter by that.

KJ wrote:

Excel 2000
I have a list of various dates from various years.
Type 7/3/2000 the cell shows "July 3, 2000"
Again I have various years involved... I can't figure out how to filter or
autofilter so that I get a list of dates that fall in the month of July.
Regardless of the year I want July of 2005 and July of 1990.
Can anyone help!!


--

Dave Peterson