View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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