| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
get week day of a date
Excel worksheet formula WEEKDAY yields the value you require e.g.
=WEEKDAY(A1,1) The same can be used in VBA code e.g. MyDOW = Weekday(Range("A1"),1) -- Cheers Nigel "ashishprem" wrote in message ... Hi All, I want some help regarding date function in macro. I want to know the week day number of the date. For eg on 30/12/2005 its Friday. I want the week day number. For eg Sunday -1 ,Monday -2 .... Friday -6 Saturday - 7. For 30/12/2005, the result will be 6. Is there any function to get the week day number? Regards Ashish -- ashishprem ------------------------------------------------------------------------ ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485 View this thread: http://www.excelforum.com/showthread...hreadid=532162 |
| 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
