.. Got everything to work just fine.

Glad to hear that, Paul !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Jan 25, 1:55 am, Lancer940
wrote:
Max,

Final update. Got everything to work just fine. Thanks to your previous
post.

The formula in cell A3 of the output worksheet is ('DT Stats' is the name of
the source data worksheet):

=IF(ROW(A1)COUNT($S:$S),"",INDEX('DT
Stats'!A:A,MATCH(SMALL($S:$S,ROW(A1)),$S:$S,0)))

In cell S3:

=IF(OR('DT Stats'!B3="",$B$1="",$D$1=""),"",IF(AND('DT Stats'!B3+0=$B$1,'DT
Stats'!B3+0<=$D$1),ROW(),""))

The data in both worksheets starts from Row 3. The date from the source
data ('DT Stats') is in Col B. The from/to dates are in cells B1 and D1.

Thank you very much for taking the time to help me out.
Kind regards,
Paul