### Title

Creating a sub summary of data by weeks that begin on Monday

### Post

I am pretty new at this and searched the forum where I came up with this calculation for a field I called Weekly:

DateField - DayofWeek(DateField) + 2 for a Monday-Sunday week.

I created Sub-summary report based on this field and sorted it by that field. It works except that it includes the Sunday prior to the Monday I want the week to begin with. Is there a way to get Filemaker to recognize Monday as the first day in the week?

Let ( dw = DayofWeek(DateField) ; DateField - dw + 2 - 7 * (dw = 1 ) )