display the day of the date

[Guest]

hi community

can community assist me in how am I to display the day of the date

example

when I enter a date, say, 13-11-2007 (formatted as dd-mm-yyyy) it will be
able to indicate as Tuesday in another cell (pls view below example:

eg:

A B C

1 13-11-2007 Tuesday

2

thanks community for the assistance render

 

[Peo Sjoblom]

You can either just link to the cell, if we assume that A1 holds the date
then use

=A1

do format>cells>number>custom and use

dddd


otherwise use


=TEXT(A1,"dddd")

that way you don't have to do any formatting


--


Regards,


Peo Sjoblom

 

[Pete_UK]

You can just put:

=A1

in B1 and use a custom format for B1 - set to dddd.

Hope this helps.

Pete

 

[Guest]

hi
create a special format. format>cells>special
then type into the input box.....
ddd - will display tue
dddd - will display tuesday
format column B with this spcial format then put this formaula in column B...
=a1
this formual will look a column a for a data then display the day.
there is also a format to display the day and date in the same cell.

Regards
FSt1