Dynamic date range

[Crazy AL]

I have a pivot table based on customer name (vertially, rows) and product
(across, columns). In each record is the date.
How can I base my pivot tables selection on a dynamic date range.
Specifically to display records only as far back as 6 months. Lets say
"today less 182 days", if that makes it easier.

Thanks,

AL

 

[Bernie Deitrick]

AL,

What I prefer doing is putting a column of TRUE/FALSE formulas into the
source range, like

=A2>(DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())))

Then use that column as a page or row field, choosing TRUE.

HTH,
Bernie
MS Excel MVP