Monday of each week

  • Thread starter Thread starter DOYLE60
  • Start date Start date
D

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
 
DOYLE60 said:
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.
Click to expand...


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