Inserting day of week along with date

Solved/Closed

martin firth - Nov 12, 2008 at 07:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 27, 2019 at 11:09 AM

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

Excel day of week and date in same cell
Windows calendar show week number - Guide
Dash becomes date on excel ✓ - Office Software Forum
Time of day clock stopped - Guide
It usually takes us just over a day to review your information - Facebook Forum
How to change date format in excel - Guide

1 response

Answer 1 / 1

Newrone
Nov 12, 2008 at 06:46 PM

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

Pete
Feb 1, 2009 at 10:24 AM

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
Oct 4, 2011 at 06:46 PM

great !!!

Chapel Chick
Updated on Nov 14, 2017 at 07:38 AM

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 September 12, 2010 Status Moderator Last seen December 27, 2022 555 > Chapel Chick
Jun 27, 2019 at 11:09 AM

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
Jun 26, 2019 at 04:02 PM

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

Similar discussions

Conditional formating - apply on more cells

Copy rows based on a condition

Find word within cell & put value in adjacent

Copy data onto sheet only if cell has text

Excel Macro for deleting rows IF cells not...

Excel VBA Msg Box when cell meets criteria

Similar discussions

Subscribe To Our Newsletter!