Show Weekday with date???

[Rutgers_Excels]

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".

[Jonathan Cooper]

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]

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]

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.