find last day of week

I

iccsi

I would like to find last day of week from year and week information.
Are there any function available to get this?

For example, I would like to know the saturday of year:2008 and week:
20.
are there any function to get this?


Your information is great appreciated,
 
K

Ken Snell \(MVP\)

LastDayOfDesiredWeek = DateAdd("d",(WeekNumber - 1) * 7 + (7 - DatePart("w",
DateSerial(WeekYear, 1, 1), vbSunday)), DateSerial(WeekYear, 1, 1))
 
Top