Prev: Template on Server 2008
Next: Excel 2007 format cells to date format
From: HL on 1 Jun 2010 15:55
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
From: Tom Hutchins on 1 Jun 2010 16:34
In an empty column adjoining your data, try:
=TEXT(F2,"mmm")
and copy down.

Hope this helps,

Hutch

"HL" wrote:

> 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
From: Dave Peterson on 1 Jun 2010 17:11
As long as each entry in that field is a date (no empty cells and no text), then
you can create the pivottable and group the data by months (and years (I bet)).

Rightclick on the field (in the PT)
Select "Group and show detail",
Then Group.



HL wrote:
>
> 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

--

Dave Peterson
From: Roger Govier on 1 Jun 2010 17:11
Hi

Within the PT, highlight any cell with a date>right click>Group &
Outline>Group>Months

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

"HL" <HL(a)discussions.microsoft.com> wrote in message
news:88EFCB76-EBE0-4D7C-9454-612ED600BEFD(a)microsoft.com...
> 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



 | 
Pages: 1
Prev: Template on Server 2008
Next: Excel 2007 format cells to date format