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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
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
 
Upvote 0
"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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,212,102
Messages
6,105,967
Members
447,987
Latest member
rasika_99

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