basenine 5/24/2013 6:42:53 PM
Your best bet is to create a Formula date Column (Lets say, [DayOfWeek]) which will give you a start day in the week:
PrevDayOfWeek([Date Column],1) should give you a start day of Monday.
Sunday = 0, Monday = 1, Tuesday = 2… So put a # between 0 & 7 after the column in the formula.
All dates in [Date Column] will calculate to, in the formula above's case, to Monday of that week..
So the [Date Column] is set to either 25/5/2013, 24/5/2013, 23/5/2013… etc and the [DayOfWeek] column will return 20/5/2013.
You can then group all records by the [DayOfWeek] column as they have an equal value.
ps - the [DayOfWeek] column can be hidden on the record after testing