Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autofilter - custom... | Excel Discussion (Misc queries) | |||
Custom format date cells-Autofilter doesn't work right | Excel Discussion (Misc queries) | |||
custom autofilter | Excel Worksheet Functions | |||
Custom Autofilter | Excel Discussion (Misc queries) | |||
Custom AutoFilter | Excel Worksheet Functions |