Fields
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:
Formula
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.
Steps
Author
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.
