Excel: date converion

[Guest]

Excel: i need to convert date format <12/17/2004> to TEXT :< Dec 04> or <Dec
2004>. I need this data so that i can make a pivot table based on Month wise
data.

 

[David McRitchie]

You can create a helper column for use in your pivot table
D2: =TEXT(A2,"mmdd")
E2: =TEXT(A2,"yyyy")

Don't use mmm or mmmm for Jan or January as they will not sort
properly for your.

 

[Paul Sheppard]

You can create a helper column for use in your pivot table
D2: =TEXT(A2,"mmdd")
E2: =TEXT(A2,"yyyy")

Don't use mmm or mmmm for Jan or January as they will no
sort
properly for your.

Hi pradeep-kar

Try this =TEXT(A1,"mmm yyyy"), this assumes your date is in cell A1
and for 12/17/2004 will return Dec 2004, if you want Dec 04 remove 2 o
the y'

 

[Dave Peterson]

Another option is to keep your dates in the original data. But then group by
month (or month and year) inside the pivottable.