Excel help! Converting date -> month for pivot table
 

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.

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

argg....please read the question?

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

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 :thumbsup: 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.