Date to a day (Monday, Tue, etc?)
 

I would like to convert numeric dates to letter days of the week. For example,
9/13/2005 would convert to "Tuesday" or "Tue". 10/20/2005 would convert to
"Thursday" or "Thu". 11/20/2005 would convert to Sunday" or "Sun".

Is there a way to do this for all dates in the current year and future years?

Formatcellsnumbercustom and ddd or dddd, if you want them in another cell
just link to the source and
use the same custom format


--
Regards,

Peo Sjoblom

(No private emails please)


"Taylor" wrote in message
...
I would like to convert numeric dates to letter days of the week. For
example,
9/13/2005 would convert to "Tuesday" or "Tue". 10/20/2005 would convert
to
"Thursday" or "Thu". 11/20/2005 would convert to Sunday" or "Sun".

Is there a way to do this for all dates in the current year and future
years?

Hi,

You can use a formula

=Text(YourCell,"ddd") or =Text(YourCell, "dddd")

or

Format cells | Number | Custom | ddd or dddd

kk



"Taylor" wrote in message
...
I would like to convert numeric dates to letter days of the week. For
example,
9/13/2005 would convert to "Tuesday" or "Tue". 10/20/2005 would convert to
"Thursday" or "Thu". 11/20/2005 would convert to Sunday" or "Sun".

Is there a way to do this for all dates in the current year and future
years?

KK: thank you very much. I tried it and it works.

Taylor



"kk" wrote:

Hi,

You can use a formula

=Text(YourCell,"ddd") or =Text(YourCell, "dddd")

or

Format cells | Number | Custom | ddd or dddd

kk



"Taylor" wrote in message
...
I would like to convert numeric dates to letter days of the week. For
example,
9/13/2005 would convert to "Tuesday" or "Tue". 10/20/2005 would convert to
"Thursday" or "Thu". 11/20/2005 would convert to Sunday" or "Sun".

Is there a way to do this for all dates in the current year and future
years?

Peo: thank you for the answer to my question. I tried it and it works

Taylor

"Peo Sjoblom" wrote:

Formatcellsnumbercustom and ddd or dddd, if you want them in another cell
just link to the source and
use the same custom format


--
Regards,

Peo Sjoblom

(No private emails please)


"Taylor" wrote in message
...
I would like to convert numeric dates to letter days of the week. For
example,
9/13/2005 would convert to "Tuesday" or "Tue". 10/20/2005 would convert
to
"Thursday" or "Thu". 11/20/2005 would convert to Sunday" or "Sun".

Is there a way to do this for all dates in the current year and future
years?