Sort Data by Date in Pivot Table

Please attach a sample workbook so we can work with your own data to work out possible solutions. Remember to remove or replace any sensitive data before uploading your file.

It's because the Month column in your data sheet is not formatted as dates. Once you change this format and refresh the pivot table it will sort correctly. You will need to change the format of the date cells in the data sheet and pivot tables to your preferred format of mmm-yy.

To sort, in the pivot table right click on the "Month" cell, select Sort, A-Z or Z-A whichever you prefer.

Select the date cells then right click. Select Format Cells and click on Date in the left column. In the right hand column you will see the various date formats. Scroll down and click on the one that looks like "14-Mar-01". Now click on Custom in the left column and you will see the formula Excel uses to format the date. Delete dd- and click OK. The format of your daets should now be Jul-14.