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
