week of the year

  • Thread starter Thread starter Maracay
  • Start date Start date
M

Maracay

I guys,

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

Thanks
 
I guys,

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

Thanks
Click to expand...

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?)
 
Back
Top