create a month column from date column

J

jcontrer

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
 
Y

Yanick

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

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

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

sidm via OfficeKB.com

jcontrer said:
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

Hi
The simplest that I can think of is that you format f2 as mmm/yyy (Rightclick
on F2 >format>custom>mmm/yyyy) after copying the date from e2 to f2
 
D

David Biddulph

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

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

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

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

Jack

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top