Search : in
By :

Inserting day of week along with date

Last answer on Feb 1, 2009 3:24:05 pm GMT martin firth, on Nov 12, 2008 12:46:42 pm GMT 
 Report this message to moderators

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

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Inserting day of week along with date » in :
Excel tips : How to insert date in a cell Show Excel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Finding and using file date in batch command Show
Mktime() - Timestamp yesterday, last month, etc.). Show Mktime() - Timestamp yesterday, last month, etc.) Intro Last 24 hours Yesterday This week Last week This Month Last 30 days (last 30 days) Last month Current year(this year) Last year (last year) Intro The mktime()function...
Inserting text in a file ShowInserting text in a file Introduction Syntax Introduction It is sometimes useful to insert text in the header of one or more document (s) or in a specific part of the document (before or after a specific line). The publisher of...
Inserting an image in gmail when composing a message ShowInserting an image in gmail when composing a message Here is a great way to insert images in your Gmail e-mails. Guaranteed results! Since you have a Gmail account (since you ask this question) you need access to Google Docs. This...
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Download ComputerTime Show
Download Clalendar Browser for Outlook ShowCalendar Browser for Outlook is a program to organize your resources (appointments, reservations, etc.) to the calendar of MS Outlook. It allows you to create a link between the resources and to have visualization on the calendar of the day, week...
Download DBPix ShowDBPix enables you to insert images in Access databases. Thanks to Access Image Control, you can optimize storage, performance, display quality, rotate image without quality loss, view camera and photo information and metadata. The application...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Data transmission - Introduction ShowData representation The purpose of a network is to transmit information from one computer to another. To do this, you first have to decide how to encode the data to be sent, in other words its computer representation. This will differ according to...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Ask your question Reply

1

Newrone, on Nov 12, 2008 11:46:18 pm GMT
  • +3

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

   
Reply to Newrone

2

 Pete, on Feb 1, 2009 3:24:05 pm GMT

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

   
Reply to Pete
Ask your question Reply
They need your help