How do I format cells from numerical dates to text month in a dif.

[johntokay]

I am trying to split dates into different cells for a chart however when the
month is formated for text it always reads January. Any help please

 

[Don Guillett]

a bit more explanation please

 

[johntokay]

In column A there is a list of dates thusly formatted: 01/30/2000,
01/31/2000, 02/01/2000, 02/02/2000. In column B there is some other
information needed for the chart. For chart purposes I what to split the
dates out into seperate colums C for year, D for month, E for day, and
finally F Day of the week. When trying to put the month column into text
instead of numerical everything comes up January. I have tried to change the
value to 5 in an individual cell and still get January when the sheet should
change to May.
BTW: Thanks for you consideration.

 

[Don Guillett]

try this if column A is properly formatted dates

=year(a1)
=month(a1)
=day(a1)
=format(a1,"dddd")

 

[johntokay]

Your suggestion works great for the days of the week, but not the months, I
tried =month(A1) and formatting for text month, everything changes to January
in office 2003 excell for me :-(