Menu

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

Report
-
TrowaD
Posts
2586
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 20, 2020
 -
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

Answer 1 / 1

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

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

CCM 5374 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

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
TrowaD
Posts
2586
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 20, 2020
 390 > 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

Thank you so much. From Janet of Sydney Australia. Age 75 yrs.
Ask a question