software

Please Help! I've tried all morning to auto filter a range of dates using
quot;greater than or equal toquot; and/or quot;but less than.quot; I've tried every scenario
the auto filter offers with no luck. Out of the twelve months listed for
birthdays, I simply want to get all of the February birth dates only. So, for
example, I choose quot;is greater than or equal to 1/1 and/or quot;is less than or
equal to 3/1. With those perimeters chosen, I would expect to get all of the
2/ or February dates!

Nothing I do gets this list filtered. I'm soooooo frustrated! Can anyone
help?

It might be easier to use a helper column (i.e. another column next to
your data in which you can add a formula). I would suggest a formula
such as:

=MONTH(A2)

assuming your dates start in A2. Copy the formula down, and use this
column to filter looking for months (obviously, February is 2).

Hope this helps.

PeteHi Candy,

If you're using the Custom filter box, for February use 2/1/2006 for the
first entry and 3/1/2006 for the second. If you're using VBA you can do it
this way:

.AutoFilter Field:=3, Criteria1:=quot;gt;=quot; amp; CDate(Range(quot;M1quot;)), _
Operator:=xlAnd, Criteria2:=quot;lt;quot; amp; CDate(Range(quot;N1quot;))
where M1 and N1 hold your dates. Or:

.AutoFilter Field:=3, Criteria1:=quot;gt;=quot; amp; CDate(quot;2/1/06quot;), _
Operator:=xlAnd, Criteria2:=quot;lt;quot; amp; CDate(quot;3/1/06quot;)

For the manual method you need the full year spelled out.

CHORDially,
Art Farrell

quot;Candyquot; gt; wrote in message
...
gt; Please Help! I've tried all morning to auto filter a range of dates using
gt; quot;greater than or equal toquot; and/or quot;but less than.quot; I've tried every
scenario
gt; the auto filter offers with no luck. Out of the twelve months listed for
gt; birthdays, I simply want to get all of the February birth dates only. So,
for
gt; example, I choose quot;is greater than or equal to 1/1 and/or quot;is less than or
gt; equal to 3/1. With those perimeters chosen, I would expect to get all of
the
gt; 2/ or February dates!
gt;
gt; Nothing I do gets this list filtered. I'm soooooo frustrated! Can anyone
gt; help?