Grouping data by week

Migrateduser

Hello all.

Hopefully you can help me here. I've had a search through the forum and google and haven't been able to find the out what I am trying to do. so here goes.

I'm putting together a report that needs to have it's data grouped by month and week. Of which I think I have gotten working (the month works perfectly).

The issue I'm having is that I would like to have the data that is goruped by the week to have a heading

Week Starting: Mon 17 January 2001

Currently all I can get is the date of the first piece of data that is being grouped (i've turned repeat header off).

Is there an easy way to group data weekly and also get the dat of the first day of the week to use in the header?

Thanks in advance