MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.