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