Converting Date to Day of Week
 

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


--
QuestGAV
------------------------------------------------------------------------
QuestGAV's Profile: http://www.excelforum.com/member.php...o&userid=17432
View this thread: http://www.excelforum.com/showthread...hreadid=478135

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?

Converting Date to Day of Week
 

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

"QuestGAV" wrote in
message ...

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


--
QuestGAV
------------------------------------------------------------------------
QuestGAV's Profile:
http://www.excelforum.com/member.php...o&userid=17432
View this thread: http://www.excelforum.com/showthread...hreadid=478135

Converting Date to Day of Week
 

Beautiful, thanks!


--
QuestGAV
------------------------------------------------------------------------
QuestGAV's Profile: http://www.excelforum.com/member.php...o&userid=17432
View this thread: http://www.excelforum.com/showthread...hreadid=478135