Excel help! Converting date -> month for pivot table

[Ferra]

Anyone knows how to convert a full date (ex. May, 30, 2009) to simply month-year (May, 09.)

I don't want to make the date to simply "display" as Month-Year. (which I can do by simply formatting the cell format to mmm-yy). I need dates such as May 1, 2009, and May 30, 2009, to become same/equivalent value.


*Basically..what I am trying to do is to categorize a bunch of date into month/year so I can use it in a pivot table.

[Jsunu]

right click -> format cells -> number -> date format or something like

[Ferra]

Originally Posted by Jsunu

right click -> format cells -> number -> date format or something like

argg....please read the question?

[Ferra]

btw..i. am looking for a "short" way of doing it..

What I am doing now is basically adding 3 extra columns, one to fetch month(), one to fetch year(), and then combine the 2 strings in the 3rd columns. (*so I get result like "2009-05" for all the dates in 2009 May)

I am hoping I can do that w/o adding the extra columns or writing a very long function formula.
Is there any present function or shorter way of doing it?xcel that can do that

[Eclypz]

You can group columns in pivot tables
In your pivot table, Right click the date column -> group -> month
(Based off of memory, so it might not be exact)
Posted via RS Mobile

[Ferra]

Originally Posted by Eclypz

You can group columns in pivot tables
In your pivot table, Right click the date column -> group -> month
(Based off of memory, so it might not be exact)
Posted via RS Mobile

Thanxx That worked!

I remember there was this option too, but somehow couldn't do it earlier.. Turns out there were a few blank cell in the row and that somehow prevented me from using the proper grouping option.