Using Dates Ranges to Alter Pivot Table Data Set

[thabounceisback]

A little new to the forum, so I appreciate your help and patience.

I would like to use a pivot table to manipulate my data. However, I need to be able to select data within my data set by a range of dates (usually a week). Is there a way to use a pivot table but reduce the data set by a user enter range of dates?

The date field is the first column in my data sheet.

Thanks,
Kurt