Previous Topic Next Topic

Inserting day of week along with date

Solved/Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 -
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
Related:

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.
48
Thank you
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 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
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
 490 > 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