Yesterday [in Episode #1678], Bill looked at a solution for sorting using Dates that were entered into a Data Set Formatted as Text, using PowerPivot; today he will address Dates entered with Text Formatting in a Pivot Table. Follow along with Episode #1679 as Bill shows us how to ‘Fix’ the Date Column and work with the Data Set in a Pivot Table.


Pivot Table Data Crunching: Microsoft Excel 2013– by Bill ‘MrExcel’ Jelen and Michael Alexander
Crunch any data, from any source, quickly and easily, with Excel 2013 Pivot Tables! Use Excel 2013 Pivot Tables and Pivot Charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!

For all of your Microsoft Excel needs visit

Your One Stop for Excel Tips and Solutions