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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
try this if column A is properly formatted dates

=year(a1)
=month(a1)
=day(a1)
=format(a1,"dddd")
 
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 :-(
 
Back
Top