I have a column in which the date is entered in mm/dd/yyyy format.
what i would like to have is another column that takes that information and
gives me the month in word format and the year in number format.

so for example:
if e2= 05/07/2009
i would like to have f2= May 2009

is that possible? if so, How do I do that?
your help will be greatly appreciated
--
thanks in advance

In F2, enter:
=E2 and format F2 as Custom > mmmm yyyy
--
Gary''s Student - gsnu200909


"jcontrer" wrote:

> I have a column in which the date is entered in mm/dd/yyyy format.
> what i would like to have is another column that takes that information and
> gives me the month in word format and the year in number format.
>
> so for example:
> if e2= 05/07/2009
> i would like to have f2= May 2009
>
> is that possible? if so, How do I do that?
> your help will be greatly appreciated
> --
> thanks in advance

On Jan 14, 12:12*pm, jcontrer <jcont...@discussions.microsoft.com>
wrote:
> I have a column in which the date is entered in mm/dd/yyyy format.
> what i would like to have is another column that takes that information and
> gives me the month in word format and the year in number format.
>
> so for example:
> if e2= 05/07/2009
> i would like to have f2= May 2009
>
> is that possible? if so, How do I do that?
> your help will be greatly appreciated
> --
> thanks in advance

Use this formula : =Date(year(e2),month(e2),1)

Only need to change the cell format to display the right date format.

Why bother changing it to the first of the month?
--
David Biddulph

"Yanick" <(E-Mail Removed)> wrote in message
news:4e0b7a71-745f-46f7-99ff-(E-Mail Removed)...
On Jan 14, 12:12 pm, jcontrer <jcont...@discussions.microsoft.com>
wrote:
> I have a column in which the date is entered in mm/dd/yyyy format.
> what i would like to have is another column that takes that information
> and
> gives me the month in word format and the year in number format.
>
> so for example:
> if e2= 05/07/2009
> i would like to have f2= May 2009
>
> is that possible? if so, How do I do that?
> your help will be greatly appreciated
> --
> thanks in advance

Use this formula : =Date(year(e2),month(e2),1)

Only need to change the cell format to display the right date format.

If I change the format in F2, how can I run a subtotal of all values for May?
How can I create a pivot table that groups all the values in May when I use
F2 as a column header? (it creates a column for each distinct day of the
month instead of a May column). Is there a way of doing so? I'm on XP with
Excel 2003. Thanks, jn

"Gary''s Student" wrote:

> In F2, enter:
> =E2 and format F2 as Custom > mmmm yyyy
> --
> Gary''s Student - gsnu200909
>
>
> "jcontrer" wrote:
>
> > I have a column in which the date is entered in mm/dd/yyyy format.
> > what i would like to have is another column that takes that information and
> > gives me the month in word format and the year in number format.
> >
> > so for example:
> > if e2= 05/07/2009
> > i would like to have f2= May 2009
> >
> > is that possible? if so, How do I do that?
> > your help will be greatly appreciated
> > --
> > thanks in advance