You would need a help column

assume the dates start in B2

in the help column use

=MONTH(B2)

copy down and filter on the help column, if you select 2 you would filter
for feb

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Ducky" wrote in
message ...

I have a list of dates and I am trying to filter them by month. The
only problem is that it will only filter the dates in 2006. I have
tryed some things and played around with it but I just can't get it.


--
Ducky
------------------------------------------------------------------------
Ducky's Profile:
http://www.excelforum.com/member.php...o&userid=33235
View this thread: http://www.excelforum.com/showthread...hreadid=530575