Day of the week

B

BulaMan

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
 
H

Harald Staff

Hi

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

HTH. Best wishes Harald
 
H

Harald Staff

Ron Rosenfeld said:
Actually:

=LEFT(TEXT(A1,"ddd"),2)
Click to expand...

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

Best wishes Harald
 
R

Ron Rosenfeld

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

Best wishes Harald
Click to expand...

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


--ron
 
Top