I have a date dimension in the FILTERS part of an Excel 2013 Pivot Table. I want to easily filter for all the dates in a range but i have to check and uncheck tons of checkboxes while i would like to just specify two dates. I can do this when the dimension is in the ROWS but i can't understand how to do the same in filters.
Have you considered using a Timeline filter instead of a regular filter or slicer?
You just need to have a field that is a date. Use it to create the timeline (on the Insert tab in Excel, choose Timeline). Then you can select the level/time period (date, month, quarter, year) at which you want to create your date range and click and drag to create the range. More details are in the link.