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?
|