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
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top