Thread: Day of the week
View Single Post
  #2   Report Post  
Harald Staff
 
Posts: n/a
Default

Hi

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

HTH. Best wishes Harald

"BulaMan" skrev i melding
...
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