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