Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The WEEKNUM function is used to determine the week number of a specific date within a year. This function is particularly useful for organising and analysing data every week.
Syntax
WEEKNUM(date)
The WEEKNUM function syntax has the following arguments:
- date Required. Dates should be entered either by using the "YYYY-MM-DD" format by using the DATE function, or as results of other formulas or functions.
Example
| Formula | Description | Result |
|---|---|---|
| =WEEKNUM("2022-01-03") | Number of the week in the year that 2022-01-03 occurs. | 1 |
| =WEEKNUM("2022-01-01") | Number of the week in the year that 2022-01-01 occurs. | 52 |
Errors
For a full list of formula errors, please read Formula errors.