View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default How to get days of week by entering dates?

Depending on the format you want displayed.

Full day name:
=TEXT(A1,"dddd")

Three letter day name:
=TEXT(A1,"ddd")

HTH,
Paul
--

"jspaeth" wrote in message
...
How do I set up a function that when I "input a date it gives me the day
of
the week" in another column?