In the pivot table shown, there are four fields in use: Date, Location, Sales, and Filter.  Location is a Column field, Date is a Row field, Sales is a Value field, and Filter (the helper column) is a Filter field, as seen below:


The formula used in E5, copied down, is: This formula returns TRUE when a record date is greater than or equal to today’s date - 7, and also less than today’s date. 



Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Pivot table last 7 days - 8