Month Filter

J

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
 
D

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
 
Top