Used in a formula column, the WEEK() function extracts the week number from a date-type column, as a number. It is used as a weekly grouping key: tracking production by week, scheduling, weekly reporting.
Syntax
WEEK(date_column)
Parameters
Examples
Extract the week number
The formula returns the week number corresponding to the date.
WEEK($Date)
Tip: for unambiguous chronological sorting from year to year, combine WEEK() with YEAR() or use YEAR_WEEK().
Go further
WEEK_ADD()
Add weeks to a date instead of extracting the week number.
Or continue with
Formula glossary
All available operators and functions, sorted by category.