WEEK/WEEK_OF_YEAR

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

Updated over a week ago

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)

Output

integer

Variables

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

Example

WEEK(`Event Date`)

Event

Event Date

WEEK

Event A

2023-09-10

36

Event B

2023-08-25

34

Event C

2023-01-15

2

Event D

2023-12-31

52

Did this answer your question?