Distinct list of dates from the large list based on criteria

I have a large list of dates. I want to create a distinct list from the large list based on criteria, only values within a specific date interval as per the attached sample file. Appreciate any assistance in the matter. thanks

thanks bro, which formula is more effective (Array or non-array) considering that I have a huge amount of data.

Also, the formula doesn't use the start and end date., I want unique dates based on the selection criteria, is this possible? thanks

I don't want to display all unique values. Only values falling within the start and end date should be displayed. As per the existing formula, all unique values are displayed as follows:

Unique distinct list
4-Jan-09
5-Jan-09
8-Jan-09
10-Jan-09
12-Jan-09
16-Jan-09
17-Jan-09
18-Jan-09
28-Jan-09

how can I get unique values falling between a range e.g. 10-Jan-09 to 15-Jan-09 (the answer should be 10-Jan-09, 12-Jan-09). Hope the query is clear now. Thanks

thanks a lot for the assistance

Originally Posted by Bo_Ry

Please try at
C2 with 3 columns array
=IFERROR(AGGREGATE(15,6,$A$2:$A$18/($A$2:$A$18>MAX(C$1:C1))/($A$2:$A$18>=$F$1)/($A$2:$A$18<=$F$2),1),"")



or
D2 a bit longer but faster with less array calculation 2 columns array
=IFERROR(AGGREGATE(15,6,$A$2:$A$18/($A$2:$A$18>MAX(D$1:D1))/(ABS($A$2:$A$18-($F$2+$F$1)/2)<=($F$2-$F$1)/2),1),"")

the formula resolved the issue in 2 ninutes which i couldn't do in the last two days. thanks for all the assistance.