Thread: Day Of The Week
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default Day Of The Week

Yes.

Just type the date as an Excel date (like 04/21/1949 and choose one of the
date formats in the format menu to get for example

Thursday, April 21, 1949


--
Kind regards,

Niek Otten



"lsmft" wrote in
message ...

Does Excel have the ability to show the day of the week for dates of
long past?
Example:
If I were to type into a cell the date 04/21/1949, can Excel show the
day of the week that 04/21/1949 fell on?
Thank you for your help!!


--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=516374