| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Threaded Mode
