Auto Filter Question?

[Ducky]

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.

[Peo Sjoblom]

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" <Ducky.25uq0o_1144341607.8732@excelforum-nospam.com> wrote in
message news:Ducky.25uq0o_1144341607.8732@excelforum-nospam.com...
>
> 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
>

[neomemphis]

Create another column, assign it to your dates(=b2) and change its format to Date and select M as the type this would convert your dates into the first letter of the months and now apply filter. The drawback of this idea is the system couldnt distinguish between March and May, April and August etc.

[Ducky]

I am sure that would work but the way that I have to do it that wont work. Let me give you an example.


Date

jan/5/06
eb/1/06
mar/3/05
mar/27/06
dec/16/06
dec/13/98


I Have macros that will sort just by month and year but we need it sort by just month.