Thread: How do I get a cell to show the day of the week when date entered
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Captain
 
Posts: n/a
Default How do I get a cell to show the day of the week when date entered


"Captain" wrote:

How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.

Thanks! Is there a way to get the week # for a specific date?
Reply With QuoteReply With Quote