Filter dates between dates

Paul B

Well-known Member
Joined
Feb 15, 2002
Messages
577
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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Use autofilter. Then, hit the dropdown arrow and choose Custom. You'll know where to go from there.

:)
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
For the criteria, consider how your system is configured for dates.

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

HTH
 
Upvote 0

Forum statistics

Threads
1,213,511
Messages
6,114,054
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top