Day of the week

[Guest]

I was able using several worksheet functions and cells to convert the day of
the week function returning the 1-7 intergers to what is needed Mo, Tu, We,
etc.
I was not able to combine all into one formula for one cell and have it
work. Is there a way to do this. Given a Date - Have it return the text
version of day of the week. BULAMAN

 

[Harald Staff]

Hi

For Mo:
=TEXT(A1,"ddd")
for Monday:
=TEXT(A1,"dddd")

HTH. Best wishes Harald

 

[Frank Kabel]

Hi
just use the custom format
DDD

 

[Ron Rosenfeld]

For Mo:
=TEXT(A1,"ddd")

Actually:

=LEFT(TEXT(A1,"ddd"),2)


--ron

 

[Harald Staff]

Actually:

=LEFT(TEXT(A1,"ddd"),2)

That so ? Differences between regional settings then. It returns two letters
here in scandinavia. Ok, thanks Ron.

Best wishes Harald

 

[Ron Rosenfeld]

That so ? Differences between regional settings then. It returns two letters
here in scandinavia. Ok, thanks Ron.

Best wishes Harald

Hmm. I never knew that. It is three letters in the US. I don't know about
other countries.


--ron