Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
I've searched through the posts, but I can't seem to find an answer so I'm posting my question. I'm looking for a way to determine the date range (first and last day) of a week when given the week number. So if I'm given week 25 of 2007, I would find the first day is June 18, 2007 to June 24, 2007 (assuming first day of the week is Monday). All I can think of is to count up from Jan. 01, 2007 and if it isn't the right week number, keep counting up until I find the first date that matches the week number. Just curious is anyone knows of an existing (or more elegant) way to determine the date range of a week. Any suggestions are appreciated. Thanks, Jay -- Disregard, this is so I can find my post later. ***postedbyJay*** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 | |||
Check if Date within this week/last week | Excel Programming | |||
from date return week date range | Excel Worksheet Functions | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |