View Single Post
  #2   Report Post  
Rowan Drummond
 
Posts: n/a
Default Converting Date to Day of Week

If you an answer like "Thursday" then:
=TEXT(A1,"dddd")
or you can use the WEEKDAY function to return the day of the week
=WEEKDAY(A1)
1 = Sunday, 2 = Monday etc.

Hope this helps
Rowan

QuestGAV wrote:
Is there a function that will take a date (eg. 10/20/05) and yield the
corresponding day of the week?