Custom Date in Autofilter

[Michael Singmin]

Hello Group,

I have a column of dates covering Jan - May 04.
I would like to use the Custom function of the Autofilter.
Can this be setup to filter those dates in Feb only ?

I know there are other ways to do this but I am interested in
what Custom can do.

Thanks,

Michael Singmin

 

[Frank Kabel]

Hi
you could use the following two conditions:
Greater or equal than: 2004-2-1
Less than: 2004-3-1

 

[Tom Ogilvy]

For the custom setting, use two conditions joined by and:
is less than or equal to end of month and greater than or equal to beginning
of month

 

[Michael Singmin]

Thank you Frank and Tom,

I was playing around with Date,Year and Month and getting no where.
As so often with questions, the solution is so simple.

Many thanks,

Michael
==================================================================