Day of week
Posted by Paul C. on August 22, 2001 11:42 AM
Can excel assign "Monday", "Tuesday", etc. to a variable in VBA using some variation of the now() statement? i.e. x = ????(now()) ==> x ="Wednesday"
Posted by IML on August 22, 2001 11:46 AM
I don't know if this will help, but without VBA, you could use:
=TEXT((NOW()),"dddd")
good luck.
Posted by Paul C. on August 22, 2001 11:55 AM
No good. But thanks anyway. I am trying to use it in a message box.
Paul C.
