help with dates
 

I want to refer to a cell that contains a function to display today
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

--
juster2
-----------------------------------------------------------------------
juster21's Profile: http://www.excelforum.com/member.php...fo&userid=2539
View this thread: http://www.excelforum.com/showthread.php?threadid=38865

help with dates
 

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

help with dates
 

If it's today's date, why bother with the cell

Format(Date,"dddd")

--
HTH

Bob Phillips

"Niek Otten" wrote in message
...
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