software

I have a column formatted as a date field and need to do advanced filtering
on it. For example, I want to filter out entries between two dates. When I
build the criteria range and use a single criteria, everything works as
expected. When I add the second criteria (gt;1/31/05 and lt;3/1/05 to see only
Feb. entries) the filter doesn't function. I've tried both entries in the
same column, adding a second quot;Datequot; column and putting each entry on a
separate line under both, and nothing seems to work. Any suggestions would
be welcome. Thanks!

Enter the criteria in separate columns, and in the same row.

There's an example he

www.contextures.com/xladvfilter01.html#CriteriaRusty wrote:
gt; I have a column formatted as a date field and need to do advanced filtering
gt; on it. For example, I want to filter out entries between two dates. When I
gt; build the criteria range and use a single criteria, everything works as
gt; expected. When I add the second criteria (gt;1/31/05 and lt;3/1/05 to see only
gt; Feb. entries) the filter doesn't function. I've tried both entries in the
gt; same column, adding a second quot;Datequot; column and putting each entry on a
gt; separate line under both, and nothing seems to work. Any suggestions would
gt; be welcome. Thanks!--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.htmlThanks Debra, that seemed to work. I thought I had tried that as well as
separate lines, but apparently not. Your assistance is greatly appreciated.
Rusty

quot;Debra Dalgleishquot; wrote:

gt; Enter the criteria in separate columns, and in the same row.
gt;
gt; There's an example he
gt;
gt; www.contextures.com/xladvfilter01.html#Criteria
gt;
gt;
gt; Rusty wrote:
gt; gt; I have a column formatted as a date field and need to do advanced filtering
gt; gt; on it. For example, I want to filter out entries between two dates. When I
gt; gt; build the criteria range and use a single criteria, everything works as
gt; gt; expected. When I add the second criteria (gt;1/31/05 and lt;3/1/05 to see only
gt; gt; Feb. entries) the filter doesn't function. I've tried both entries in the
gt; gt; same column, adding a second quot;Datequot; column and putting each entry on a
gt; gt; separate line under both, and nothing seems to work. Any suggestions would
gt; gt; be welcome. Thanks!
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Excel FAQ, Tips amp; Book List
gt; www.contextures.com/tiptech.html
gt;
gt;