Can a day of the week be automatically included in date format when the date is typed in?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

colincurious@hotmail.com - 11 Jan 2007 17:08 GMT

I'm using Excel 2003. I know how to use Control and ; to insert a date
(and also how to use the date format command) in a cell. However, I
have to manually type in the day next to it. The date format does not
give me the option of 'Thur 11/01/2007' simply '11/01/2007'. Is there
a way of making the date format insert the date, or for the day to
automatically appear in the cell to the left of the date when that is
input?

Thanks
Colin

Reply to this Message

JE McGimpsey - 11 Jan 2007 17:56 GMT

One way:

Format/Cell/Number/Custom:

ddd d/m/yyyy

for "Thu 11/1/2007"

or

dddd d/m/yyyy

for "Thursday 11/1/2007"

> I'm using Excel 2003. I know how to use Control and ; to insert a date
> (and also how to use the date format command) in a cell. However, I
[quoted text clipped - 6 lines]
> Thanks
> Colin

Reply to this Message

colincurious@hotmail.com - 12 Jan 2007 02:25 GMT

Very simple when you know how! :-) Thanks very much, really useful!!

Reply to this Message

Rate this thread: