You could add a column of formulas to your data table, with a formula like

=A2 (TODAY()-15)

and then use TRUE as your filter...

HTH,
Bernie
MS Excel MVP


"Amijab" wrote in message
...
I have a pivot table that is updated daily, but for reporting purposes, I
only want to include the last 14 days in my report . I see date filters for
this week or last week, this month or last month, but how do I create a
custom filter for =today()-15?

Thank you!!