By far the easiest way of dealing with stuff like this is by using a Calendar table. Then you can get ANY day of ANY week...

SELECT ..

FROM CalendarTable

WHERE WeekNumber = @WeekNumber

AND DayName = 'Friday';

All you would need to go is get the database guys to create a calendar table or function (that returns a table) for you.