hi
create a special format. formatcellsspecial
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

"oldLearner57" wrote:

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