Hi

Within the PT, highlight any cell with a dateright clickGroup &
OutlineGroupMonths

--
-------
Regards
Roger Govier

"HL" wrote in message
...
I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based
on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column
that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks

__________ Information from ESET Smart Security, version of virus
signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com