Match values within a range of dates

Joined
Nov 4, 2005
Messages
18
I have a column of various dates (no duplicates). What I want to do is to find out which of those dates are between a date range. Eg

Column A
12/2/05
2/4/05
5/5/05
6/7/05

And I want to create a list of the dates that are between 1/1/05 and 1/3/05.

Any help appreciated
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
using an advanced filter:
Book1
ABCDEF
1Dates
21/01/2001FALSE
32/01/2001Start5/01/2001
43/01/2001End8/01/2001Dates
54/01/20015/01/2001
65/01/20016/01/2001
76/01/20017/01/2001
87/01/20018/01/2001
98/01/2001
109/01/2001
1110/01/2001
1211/01/2001
1312/01/2001
1413/01/2001
Sheet6
 
Joined
Nov 4, 2005
Messages
18

ADVERTISEMENT

HI,

Yes, I need to have work automatically and not use the filter each time.

Thanks
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"Yes, I need to have work automatically"

In which case, you need to provide a lot more info:

Where's the source list
Where do we get the to / from dates from
Where are the resulting records to go
What triggers an update to the selection?
What happens to previously selected items - deleted?
 
Joined
Nov 4, 2005
Messages
18
For my purposes the layout and data you provided would suit. A chnage of date would triger an update and the previously selected items would dissapear as I would only want to see the new records.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,023
Messages
5,834,996
Members
430,331
Latest member
Syed Yasir Hannan

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
Top