View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default display the day of the date

You can just put:

=A1

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

Hope this helps.

Pete

On Nov 12, 4:41 pm, 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