Menu
Ask a question Report

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

- - Latest reply: TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 - Jun 27, 2019 at 11:09 AM
Office Software Ask a question Report
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
Report
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 6897 users have said thank you to us this month

Report
-
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
Report
-
great !!!
Report
-
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.
Report Respond to TrowaD
TrowaD
Posts
2519
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 3, 2019
 361 > 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?)
Report Respond to Janet
-
Thank you so much. From Janet of Sydney Australia. Age 75 yrs.
Ask a question