Previous Topic Next Topic

Inserting day of week along with date

Solved/Closed
martin firth - 12 Nov 2008 à 07:46
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 Jun 2019 à 11:09
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 response

Réponse 1 / 1
Newrone
12 Nov 2008 à 18:46
Right-click on the cell, choose "Format cells", go to "Custom" & type "ddd dd/mm/yy" in the "Type" box.
Pete
1 Feb 2009 à 10:24
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
Needo
4 Oct 2011 à 18:46
great !!!
Chapel Chick
14 Nov 2017 à 07:36
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 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555 > Chapel Chick
27 Jun 2019 à 11:09
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?)
Janet
26 Jun 2019 à 16:02
Thank you so much. From Janet of Sydney Australia. Age 75 yrs.

Similar discussions

Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
Copy rows based on a condition
Blossom83 -
ravichennai86 -

30 responses
Find word within cell & put value in adjacent
Mr.G -
BogelBot -

39 responses
Copy data onto sheet only if cell has text
danipants -
checjb -

17 responses
Excel Macro for deleting rows IF cells not...
elmaco -
Jo -

11 responses
Excel VBA Msg Box when cell meets criteria
Iangough16 -
rizvisa1 -

9 responses