REVscene Automotive Forum - View Single Post - Excel help! Converting date -> month for pivot table

Ferra · 05-06-2010, 09:41 AM

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.

05-06-2010, 09:41 AM	#1
Ferra I don't like cheese but I love milk! Join Date: Nov 2002 Location: Van Posts: 1,980 Thanked 895 Times in 243 Posts Failed 105 Times in 49 Posts	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.