Automating my Pivot Table's Rolling Date Checklist

[elainegarner18]

Hi there,

I send out weekly reports that include data from the most recent two weeks and data from the most recent month. Each time I refresh my report with new data, I have to go in and manually uncheck the boxes of previous weeks and select the most recent checkbox. I wondered if there could be a automated way to do this (Spinner, Macro, etc.) but can't figure out anything that works. Please help!!