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

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

a bit more explanation please

--
Don Guillett
SalesAid Software

"johntokay" wrote in message
...
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.

"Don Guillett" wrote:

a bit more explanation please

--
Don Guillett
SalesAid Software

"johntokay" wrote in message
...
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

try this if column A is properly formatted dates

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

--
Don Guillett
SalesAid Software

"johntokay" wrote in message
...
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" wrote:

a bit more explanation please

--
Don Guillett
SalesAid Software

"johntokay" wrote in message
...
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

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 :-(

"Don Guillett" wrote:

try this if column A is properly formatted dates

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

--
Don Guillett
SalesAid Software

"johntokay" wrote in message
...
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" wrote:

a bit more explanation please

--
Don Guillett
SalesAid Software

"johntokay" wrote in message
...
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