| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get week day of a date
Hi All, I want some help regarding date function in macro. I want to know th week day number of the date. For eg on 30/12/2005 its Friday. I want th 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 th week day number? Regards Ashis -- ashishpre ----------------------------------------------------------------------- ashishprem's Profile: http://www.excelforum.com/member.php...fo&userid=3148 View this thread: http://www.excelforum.com/showthread.php?threadid=53216 |
| 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) | |||
![ashishprem[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
