Extract Day of Week from Date in VBA
Hi,
I have a msgbox that pops up when the user opens an excel worksheet and asks
for a specific date in the [dd/mm/yy] forrmat and stores this in a varible
called myDate.
What I would like to do is extract the first two letters of the day from
this date. So if the date input is 15/12/05, then TH (for Thursday) would be
returned.
Can anyone help with the VBA to acheive this?
Thanks.
|