VBA Easy way to convert the DAY() Integer into the Day of the Week as a string?

[jscranton]

So, I have a string in format mm.dd.yyyy that comes from user input.

I have converted the string to mm/dd/yyyy and then to a Date using DateValue().

Now I need the day of the week as String such as "Monday" or "Tuesday". I know this can be done with a loop but I am hoping to avoid.

Also, I can get easily get the three letter code with CStr(Format(DayInteger,"DDD"))

Is there no way to get the full day?

 

[puru.sve]

use.....

CStr(Format(DayInteger,"DDDD"))

 

[jscranton]

Thanks! I knew it had to be simple. I tried "DDDDDDD".