Custom Date in Autofilter
 

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

Custom Date in Autofilter
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Michael Singmin wrote:
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

Custom Date in Autofilter
 

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

--
Regards,
Tom Ogilvy

"Michael Singmin" wrote in message
...
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

Custom Date in Autofilter
 

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
================================================== ================


"Tom Ogilvy" wrote:

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