WEEK/WEEK_OF_YEAR

Determines the week number of the year for a given date or datetime

Use familiar syntax such as WEEK_OF_YEAR to determine the week number of the year for a given date or datetime.

Description	The WEEK() function calculates and returns the week number of the year for a given date or datetime. This is useful for time-based analysis, scheduling, or organizing data by weeks.
Syntax	WEEK(date)

1. date: The date or datetime for which you want to determine the week number.

Example

Table

Event	Event Date
Event A	2023-09-10
Event B	2023-08-25
Event C	2023-01-15
Event D	2023-12-31

Function

WEEK(`Event Date`)

Results

WEEK (integer)
36
34
2
52