Filter dates between dates

[Paul B]

How can you filter dates between to dates, either with auto filter or adv. Filter. I have a column with dates and would like to get the info between lets say 2-5-01 and 5-24-2001. Thanks

[Anne Troy]

Use autofilter. Then, hit the dropdown arrow and choose Custom. You'll know where to go from there.

[Aladin Akyurek]

On 2002-03-24 11:26, Paul B wrote:
How can you filter dates between to dates, either with auto filter or adv. Filter. I have a column with dates and would like to get the info between lets say 2-5-01 and 5-24-2001. Thanks

Lets say that A4:B14 houses what follows:

{"date","item";
36892,"i1";
36893,"i2";
36898,"i7";
36900,"i9";
36901,"i10";
36925,"i3";
36927,"i4";
36930,"i5";
36985,"i6";
37005,"i8"}

where the funny numbers are dates as they are internally represented.

In A1:B2 enter:

{"date","date";
">=2/5/2001",
"<=5/24/2001"}

without the double quotes, if you're wondering.

Activate A5.
Activate Data|Filter|Advanced Filter.
Check 'Copy to another location'.
Enter as 'List range', if Excel already did not so:

$A$4:$B$14

Enter as 'Criteria range':

$A$1:$B$2

Enter as value of 'Copy to', e.g.,

$D$4:$E$4

Click OK.

I get in D4:E8 as result:

{"date","item";
36927,"i4";
36930,"i5";
36985,"i6";
37005,"i8"}

Aladin

[Paul B]

Aladin, I played around with it but can't get it to work, what part goes in A1 and what goes in B2?

Dreamboat what would go in the custom auto filter?

[Aladin Akyurek]

On 2002-03-24 13:29, Paul B wrote:
Aladin, I played around with it but can't get it to work, what part goes in A1 and what goes in B2?

Dreamboat what would go in the custom auto filter?

In A1 enter: date
In A2 enter: >=2/5/2001
In B1 enter: date
In B2 enter: <=5/24/2001

Note that 'date' is a label from the sample data. I used for date criteria an inclusive between.

Aladin

[Dave Patton]

For the criteria, consider how your system is configured for dates.

You may have to use for example
>=5/2/01 or >=36927

HTH

[Paul B]

That did it, I finally got it, thanks for the help