Maybe you could just apply a different format to the original cell:

mm/dd/yyyy*_dddd
(use a space bar instead of the underscore)



schoujar wrote:

hi,

In one of my cells i want to display the weekday corresponding to a
specific date.

For example i want to display "Monday" if the date i am referring (from
another cell) as being the 05/09/2005 (5th Sept 2005).

How do I achieve this?

Cheers

Sahil

--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=400688

--

Dave Peterson