Hi everyone,

I have a pivot table with data for the month of June. There is data for each day. How can I show data for a week only at a time?

For example, Cell B1 has the week ending date i.e. 6/19/16 ( last sunday). The user can change this data to any sunday they want.

Is it possible to reference the date in that cell and only show data in my pivot table for that week (6/13/16, 6/14/16, 6/15/16...)?

Can I just edit my recorded macro?

Please Login or Register  to view this content.
Thank you in advance to any help I get with this.

- Justin