ExcelBanter - Show Weekday with date???

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Show Weekday with date??? (https://www.excelbanter.com/excel-discussion-misc-queries/81643-show-weekday-date.html)

Rutgers_Excels

Show Weekday with date???

Is there anyway to format the cell so when I enter a date the cell will
show the weekday along with the date? For instance, if I enter
04/04/2006 into the cell, the cell will show "Wed 04/04/06".

--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973
View this thread: http://www.excelforum.com/showthread...hreadid=530037

Jonathan Cooper

Show Weekday with date???

Use the following number format.

ddd mm/dd/yy

"Rutgers_Excels" wrote:

Is there anyway to format the cell so when I enter a date the cell will
show the weekday along with the date? For instance, if I enter
04/04/2006 into the cell, the cell will show "Wed 04/04/06".

--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973
View this thread: http://www.excelforum.com/showthread...hreadid=530037

Jonathan Cooper

Show Weekday with date???

I'm assuming that you didn't mean for it to say "Wed", when 4/4/06 is really
a Tuesday.

"Rutgers_Excels" wrote:

Is there anyway to format the cell so when I enter a date the cell will
show the weekday along with the date? For instance, if I enter
04/04/2006 into the cell, the cell will show "Wed 04/04/06".

--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973
View this thread: http://www.excelforum.com/showthread...hreadid=530037

Rutgers_Excels

Show Weekday with date???

You assumed correctly. I haven't changed my calander since yesterday.
Thanks for the help. Sometimes I overthink these little things and I
wind up not being able to see the forest for the trees.

--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: http://www.excelforum.com/member.php...fo&userid=8973
View this thread: http://www.excelforum.com/showthread...hreadid=530037

All times are GMT +1. The time now is 05:47 AM.