I have a pivot table that I would like to limit to the previous weeks date
range. How can I code something that will filter out all dates other then
the previous weeks?

The pivot table structure will be rows of employees names, columns of Dates
and a count of transactions.

In an example for today, I would want a date range of 2/3 - 2/9. Then next
week it would list 2/10 - 2/16.

Thanks for the help.