Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter on Dates
I have a sheet with a load of dates in one column. How do I do a custom
filter that just selects the dates in a month, for example July 2008?. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter on Dates
The easiest way would be a helper column formatted yyyymm, and filter by
that. -- David Biddulph "suek" wrote in message ... I have a sheet with a load of dates in one column. How do I do a custom filter that just selects the dates in a month, for example July 2008?. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter on Dates
While this is not a "custom filter", it does allow you to select all the
dates in a month you specify. Select the column with your dates in them (here I am assuming your dates are formatted m/d/yyyy... adjust for your actual date format), click Edit/Find on Excel's menu bar (or key in Ctrl+F) to bring up the Find dialog box. If you cannot see the extra options, click the "Options" button to expose them. Assuming for this example that you want to find all the July 2008 dates, put 7/*/2008 in the "Find what" field, select "Sheet" in the "Within" drop down, select "Values" in the "Look in" drop down, then click the "Find All" button and follow that by keying in Ctrl+A. You can now close the Find dialog box and all the July 2008 dates should be selected. Rick "suek" wrote in message ... I have a sheet with a load of dates in one column. How do I do a custom filter that just selects the dates in a month, for example July 2008?. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter on Dates
Use custom
greater than or equal to July 1, 2008 and less than or equal to July 31, 2008 suek wrote: I have a sheet with a load of dates in one column. How do I do a custom filter that just selects the dates in a month, for example July 2008?. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter on Dates
Maybe you like Easyfilter
http://www.rondebruin.nl/easyfilter.htm A lot of date options in this add-in -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "suek" wrote in message ... I have a sheet with a load of dates in one column. How do I do a custom filter that just selects the dates in a month, for example July 2008?. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced filter using dates | Excel Discussion (Misc queries) | |||
Filter Dates? | Excel Discussion (Misc queries) | |||
How to filter out all the partial dates from a big list of dates? | Excel Discussion (Misc queries) | |||
Filter dates by the day | Excel Discussion (Misc queries) | |||
how to filter dates? | New Users to Excel |