ExcelBanter - Filter on Dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Filter on Dates (https://www.excelbanter.com/excel-discussion-misc-queries/198325-filter-dates.html)

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?.

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?.

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?.

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

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?.