Month Filter

[Joseph]

I keep a log of checks that I receive in my department throughout the year.
I have the checks listed by date (mm/dd/yy), payee, check #, etc. What I
want to do is be able to filter the list by month (ex., March 2005). Is
there a way to do this?

Thanks
Joseph

 

[Ron de Bruin]

You can Try EasyFilter Joseph
http://www.rondebruin.nl/easyfilter.htm

 

[Dave Peterson]

Another way is to use a helper column.

Put a formula like:
=text(a2,"mmm yyyy")

or use a formula like
=a2
and give it a custom format of "mmm yyyy"

or just use a custom filter to show those dates:
greater than or equal to March 1, 2005
but less than April 1, 2005

 

[Joseph]

Thanks all for the tips - that worked for me

Joseph