View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets
 
Posts: n/a
Default 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