Weekly Report

I want to make the weekly sales report in which i would take the parameter END DATE.

i.e. if the user enters 04-JUL-2011

The week start from SATURDAY and end FRIDAY

the report layout will generate follows:

Current WEEK1 WEEK2 WEEK3

02-03 25/06 - 01/07 18/06-24/06 11/06-17/06

Please can some one help me in this. How to break the dates in weeks as per the given format.

I would appreicate