Thread: filtering dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default filtering dates

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