Thread: How do I get a cell to show the day of the week when date entered
View Single Post
  #3   Report Post  
Sumuwin Sumuwin is offline
Junior Member
  
Posts: 1
Default
Quote:
Originally Posted by Captain
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.

select Format, Cells, (Number) ,Custom and type ddd in the Type box.
Reply With QuoteReply With Quote