display the day of the date
 

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

display the day of the date
 

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

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

display the day of the date
 

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