Inserting day of week along with date [Solved/Closed]

- - Latest reply: TrowaD
Posts
2508
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 13, 2019
- Jun 27, 2019 at 11:09 AM
Hello,

I am currently working on a spreadsheet and trying to set the cell format so that it displays the day of te week alongside the date eg Wed 12/11/08. Is this possible? If so how?
Thanks for your ooking into this nad in anticipation of someone providing me with a solution..
martin
See more 

1 reply

Best answer
47
Thank you
Right-click on the cell, choose "Format cells", go to "Custom" & type "ddd dd/mm/yy" in the "Type" box.

Say "Thank you" 47

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 6802 users have said thank you to us this month

That is great, but I would like to know how to stick a carriage return in after the day? i.e.

Sunday
01/02/2009


Wrap text, then squash the column results in ########################

Pete
It worked! Thank you. Is there a way to get the text to wrap so that the day is on top of the date? wrap text is checked but only a single line of text is visible.
TrowaD
Posts
2508
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 13, 2019
356 > Chapel Chick -
To get the day above the date using wrap text will result in ###### using the above method.

Using the formula below will yield the desired result:
=TEXT("12-12-2009","dddd") & " " & TEXT("12-12-2009","dd-mm-yyy")

Wrap text can be found by going to cell properties and then the second tab, the one next to Number (Alignment?)
Thank you so much. From Janet of Sydney Australia. Age 75 yrs.