Try using Autofilter. Lookup in Help for more info. You can then set the
filter to just include the dates you want and only those rows will be
displayed.

Depending on the version of xl that you have, you might need to use Custom
when actually setting the filter and make it Greater than or equal to and
less than or equal to.

--
Regards,

OssieMac


"Date Less" wrote:

I have 9 columns in a large database once a week I would like to print the
rows that have a date within that week in column 4. Column 4 has dates when a
job has been performed and I don't need to print last weeks data.