determine dates in a given week

nadroj · 08-20-2006, 05:13 PM

ill cut to the chase.

given a week of year (ie this week, 33/52) how can i determine the days in that week? for this week, the days would be monday 14th through sunday 20th.

i havent looked extensively, but ive looked. i can do the opposite, ie determine the week of the year given a date.

thanks for any tips

edit: ok i discovered a way.

Code:

Dim a As New Date(Now.Year, 1, 2)
a = a.AddDays(weekNumber * 7)

'a' is now a Date object representing the first day of week 'weekNumber'.

Tinkster · 08-22-2006, 02:05 AM

And a response to stop it from auto-bumping ;}