Monday of each week

[DOYLE60]

I have a report that lists each week for the year in rows and gives data for
each salesman in columns. The formula in the query for the week is:

Week: Val(Format([Date],"ww"))

The report works but I wish to put the date of each Monday after the week
number.

How should I do that?

Thanks,

Matt

 

[Marshall Barton]

I have a report that lists each week for the year in rows and gives data for
each salesman in columns. The formula in the query for the week is:

Week: Val(Format([Date],"ww"))

The report works but I wish to put the date of each Monday after the week
number.

Monday: DateAdd("d", 1 - DatePart("w", [Date], 2), [Date])