format(range("a1"),"dddd")

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"juster21" wrote in
message ...

I want to refer to a cell that contains a function to display todays
date (7/20/05) and have the result be the day of the week (Wednesday).
I'm trying to do this in VBA. Thanks for your help.


--
juster21
------------------------------------------------------------------------
juster21's Profile:
http://www.excelforum.com/member.php...o&userid=25393
View this thread: http://www.excelforum.com/showthread...hreadid=388654