week of the year

[Maracay]

I guys,

How can I get the days of a particular week of the year, lets say the week
36 of 2009.

Thanks

 

[John W. Vinson]

I guys,

How can I get the days of a particular week of the year, lets say the week
36 of 2009.

Thanks

DateAdd("ww", 36, DateSerial(Year(Date()), 1, 1))

will add 36 weeks to January 1. See the VBA help for DateAdd - there are a few
different ways of defining the first week of the year (e.g. if January 1 is a
Saturday, is the first workday of the year in week 1 or 2?)