Converting Date to Day of Week

Q

QuestGAV

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

Rowan Drummond

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
 
B

Biff

Hi!

A couple of ways:

A1 = 10/20/2005

=TEXT(A1,"dddd")

Will return the TEXT value Thursday

Another way:

=A1

And custom format the cell as dddd

Using this method the true underlying value of the cell is the date serial
number but it's just DISPLAYED as Thursday.

Biff
 
Top