SOWEEK

The SOWEEK function returns the start date of the week for a given date. References and measures are also accepted as arguments. This function is commonly used to group data by week and calculate weekly reporting periods.

Syntax

SOWEEK(date)

Arguments

• date: The input date.

Return value

Returns the start date of the week.

Example

SOWEEK("06/05/2026")

Returns 6/1/2026, which is the start date of the week containing 06/05/2026.