I really appreciate everyone's help - still not working :(

Here's more detail:

Sheet 1: Cell A1:A2500 (date column ranging from 8/1/06-8/31/06)
Sheet 2: Cell D1 (a specific date 8/4/06)
Sheet 2: Cell D2 (a specific date 8/11/06)
Sheet 2: Cell A8 (this is the first of cells that I want a formula
that will give me the data from Sheet 1 Cell A1:A2500 if the date in
that cell is = 8/4/06 (Sheet 2: Cell D1) AND <=8/11/06 (Sheet 2: Cell
D2)

I then have 5 additional columns I want brought over if the data in
Column A matches the criteria requested.

Thanks :)
Rondia