Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
Previous Topic Next Topic

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

Report
-
Posts
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 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 2942 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
2761
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2021
 462 > 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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!