Excel - Pivot - Group Dates into Months Format

I have an excel spreadsheet, inserted into a pivot table. One column has a list of individual days of the month. Once the pivot table is created, I group the individual days as month.

The days are listed as 3/1/2015, 3/2/2015, etc.

However, when I group into the pivot table, the months are listed as simply Mar, Apr, etc.

Is there a way to add the year when grouping individual days into months in an excel pivot table?

Thank you.
exp vgAsked:
Who is Participating?

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

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.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
how's ur original worksheet looks like? do u hav column of "Month Year" for the dates? u can simply create this column and use it in ur pivot table then.

the formula for this "Month Year" column could be like:

=TEXT(yourdate, "MMM YYYY")
exp vgAuthor Commented:
This is close, but what I am hoping for is to just add a year extension in the pivot table itself after grouping.




Mar 15 or Mar 2015

Thank you.
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
how's your pivot table currently looks like? can you upload one sample here?
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

exp vgAuthor Commented:
I cannot upload the source data, but here is the resulting pivot table:

             Mar      Apr      May      Jun      Jul      Grand Total
Loc A      1              3                      4
Loc B            1             1                2
Loc C            6       15       3      5         29
Loc D      262      366      382      370      124         1504
Grand Total      263      373      400      374      129      1539
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
ok, got that... just click on the "Months" and "Years" in the Grouping dialog box

Grouping in pivot table

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
exp vgAuthor Commented:
Thank you.
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.