| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA-How to calc the day (number) for the Monday of Current Week
Asking the group for assistance on calculating in VBA the Date for Monday of
the current week (Using Monday as the first day of week). This has to work across years accurately. Ex., 12-29-08, 01-05-09 etc. I've tried looking at the posts and can't seem to figure it out. I've used the WeekStart and YearStart functions from the C Pearson website and am unable to get them to work for what I need. Tried using the calc below to get the right day. Getting the month and year is easy but the day is a bit tricky. Guess I'm just doing it wrong. sDay = DatePart("d", WeekStart(DatePart("ww", Now, vbMonday, vbFirstFullWeek), CInt(Year(Now)))) -- Edwin Kelly Houston, TX |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Current year and current week number | Excel Discussion (Misc queries) | |||
| Display Monday of each week | Excel Discussion (Misc queries) | |||
| Formula to determine number of current records by week | Excel Worksheet Functions | |||
| Show week number in current month | Excel Discussion (Misc queries) | |||
| How can I get the monday of a given week number? | Excel Discussion (Misc queries) | |||
Threaded Mode
