In a formula-type column, the YEAR_WEEK() function displays the year and week of a date-type column. It serves as a reliable weekly grouping key across multiple years: weekly reporting, pace tracking.
Syntax
YEAR_WEEK(date_column)
Parameters
The output format of the column can be chosen in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Examples
Display the year and week
YEAR_WEEK($Date)
The column returns the year and the corresponding week number for the date.
Placing the year before the week ensures correct chronological sorting when moving from one year to the next.
Go further
YEAR_MONTH
Combine the year with the month for reliable chronological sorting.
Or continue with
Formula glossary
All available operators and functions, sorted by category.