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