Excel: How to Filter a Pivot Table on Date Range (4 Methods)
In this video I cover 4 ways to filter a pivot table based on a range of dates. The 4 methods are:
1. Use the Filter area in the Pivot Table Fields Panel
2. Add a Timeline to the Pivot Table
3. Add a Slicer to the Pivot Table
4. Allow the user to type the first and last dates into two cells and use a formula-based filter
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/24f4fxfoivjvezv...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #pivottable #dates #filter