Converting a date to a day
 

How can I display the day of the week automaticly based on another cell
which has a date in it?


--
stra03
------------------------------------------------------------------------
stra03's Profile: http://www.excelforum.com/member.php...o&userid=29248
View this thread: http://www.excelforum.com/showthread...hreadid=489730

Converting a date to a day
 

Hi

Use formula like
=A1
and format the cell with formula as Cusrom "ddd" or "dddd"


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"stra03" wrote in
message ...

How can I display the day of the week automaticly based on another cell
which has a date in it?


--
stra03
------------------------------------------------------------------------
stra03's Profile:
http://www.excelforum.com/member.php...o&userid=29248
View this thread: http://www.excelforum.com/showthread...hreadid=489730

Converting a date to a day
 

Works perfect ! Thx.


--
stra03
------------------------------------------------------------------------
stra03's Profile: http://www.excelforum.com/member.php...o&userid=29248
View this thread: http://www.excelforum.com/showthread...hreadid=489730