find last day of week

  • Thread starter Thread starter iccsi
  • Start date Start date
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,
 
LastDayOfDesiredWeek = DateAdd("d",(WeekNumber - 1) * 7 + (7 - DatePart("w",
DateSerial(WeekYear, 1, 1), vbSunday)), DateSerial(WeekYear, 1, 1))
 
Back
Top