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

=A1

do formatcellsnumbercustom and use

dddd


otherwise use


=TEXT(A1,"dddd")

that way you don't have to do any formatting


--


Regards,


Peo Sjoblom




"oldLearner57" wrote in message
...
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 :)



--
oldLearner57