Hi Marci
Assuming your dates are in Column A, I would use a "helper" column. In an
unused column, say Column J.
In cell J1 enter the month number you want to filter on.
in cell J2, enter the formula =Month(A2)=$J$1 and copy that formula down as
far as you need.
Then filter on Column J using the criteria "True"
--
XL2002
Regards
William
"Marci" wrote in message
...
| Can someone please tell me how I can filter the following data to show me
| only specific months. For example, I want to find all data for the month
of
| Jan. Thank You.
|
| Date
| Jan-01
| Feb-02
| Apr-04
| Jan-03
| Jan-02
|