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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fisrt and last day of month and week 2
Finding the first DAY of the week of a given week. 3
week numbers 3
Spam 4
Creating a date from week number, day number and year value 1
Query question regarding weeks 3
find day six month before 5
Count Records for this week, this month, this quarter, this year 5

Top