Pivot table month sort order

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?
TarasAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
Rather converting to text, use a function to round the date to the end/beginning of the month:

End of month
=EOMONTH(cell,0)

Beginning of Month
=EOMONTH(cell,-1)+1

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.

Thanks
Rob H
Rob HensonFinance AnalystCommented:
Alternatively, I know there is a function, but not sure how to do it, where you can group data such as dates in a Pivot Table so that you still see only the one column per month rather than a column for each day of the month.

You then wouldn't need the extra column at all.

Thanks
Rob H
TarasAuthor Commented:
Rob where to put those functions??
How to apply them? ..In source data column  or in pivot area?
 Is that used with  separate new column or existing one?
OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Rob HensonFinance AnalystCommented:
Use instead of your text conversion.
TarasAuthor Commented:
Both of them in one cell?
TarasAuthor Commented:
For not being  excel expert , Can you give me example?
Rob HensonFinance AnalystCommented:
No just one of them depending whether you want the date rounded up or down.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TarasAuthor Commented:
Thanks a lot
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.