Need start of week date.

[shophoney]

Hi I need to know the Monday's date of each week.

I have a sales table with sales and want to group all the sales by week. And need to know what week each sales fall under.

IE: 7/12/17 would return a result of 7/10/17 as it is the monday of the week.

Thanks

 

[Tetra201]

Withdrawn

 

[Justin_B]

Hi,
Use the weekday(DateSerial, return type) function to perform a calculation on the date(s) you have.
E.g. = SaleDate-(WEEKDAY(SaleDate,2)-1)
= SaleDate+(7-WEEKDAY(SaleDate,2))

Return Type 2 categorises dates Monday to Sunday, 1 to 7.