In a pivot table, if a DATE field is in the ROWS section or in the COLUMNS section I can click on that section's filter options and choose 'Date Filters'. Among other things, this allows me to set a filter between any two dates- which is very handy.
However, when I put a Date field in the FILTERS section there is no 'Date Filters' option. Why is this??!! I want to filter by date but I don't want the date to be in either the ROWS or COLUMNS section. Does anyone know a workaround that would allow me to filter by date but not include my Date field in the ROWS or COLUMNS section?
I'm using Excel 2013. Thanks.