Date Range

[Dave]

If I have a column of Dates and I need to extract all of
them between a given date range (ie. between 2/3/03-
3/1/03) how can I do this?

 

[Dave Smith]

This can be done with an Advanced Filter.

If the list on left should yield the list on the right based on the start
and end dates shown


A B C D E
1 Date Start Date End Date Date
2 9/1/2003 9/3/2003 9/7/2003 9/3/2003
3 9/2/2003 9/4/2003
4 9/3/2003 9/4/2003
5 9/4/2003 9/6/2003
6 9/4/2003 9/7/2003
7 9/6/2003
8 9/7/2003
9 9/8/2003


then setup up Advanced filter like this:

in G1 and H1 enter "Date"
in G2 enter
= ">=" & C2
in H2 enter
= "<=" & D3

Select Data > Filter > Advanced Filter
Select Copy to another location.
List Range : $A$1:$A$16
Criteria range : $H$1:$I$2
Copy to: $F$1

If you want dates to not appear more than once, check Unique records only.

Click Ok.

HTH

-Dave