I have date Column named Month formatted as "02/11/2009". In a separate column I use a =text(cell,"MMM-YY") formula to get the dates into a month format so "02/11/2009" becomes "Feb-09" in the new column. However, when I create a pivot table, it sorts the "MMM-YY" alphabetically instead of chronologically,
How to sort it properly?
End of month
Beginning of Month
The numerical parameter is the number of months to add to the date. Adding 0 months just rounds to the end of the month; -1 months rounds back to previous month end and then adding 1 to the result gives the first of the next month.
Format the result as "mmm-yy" and you will see the same result but the dates will then sort in order as expected.