There's a feature in SQL that allows you to get the week number of a date. This is usefull in grouping all the detail in a query by week.
So, now you need to report on the first day of the week. This snippet will give you the first day of the week for a given week number.
In the example we're using the Project Cost transaction table... but any table with a date will do.