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

[Taylor]

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 Sjoblom]

Format>cells>number>custom 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)

 

[kk]

Hi,

You can use a formula

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

or

Format cells | Number | Custom | ddd or dddd

kk



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?

 

[Taylor]

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

Taylor

 

[Taylor]

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

Taylor