Pivot Table Help: MMM YY

[bank_analyst]

I currently have a column of data that is formatted as "MM/DD/YYYY 0:00". I have been formatting it to "MMM YY" by using the formula "=text(cell, "MMM YY"). This accomplishes my task, but them the columns are sorted in ABC order instead of date order since it is a text and not a date field. I have tried to use the date field as is and group them by month/year, but it doesn't look the way I need it to. Any ideas?

 

[Joyner]

Hello, is there a reason you can't just formatting the actual date column to MMM YY?