Functions
WEEKNUM
Week number of the year for a date
Try it
When to use it
When should I use WEEKNUM instead of ISOWEEKNUM?
Use WEEKNUM for US-style week numbers where week 1 begins on January 1 (configurable start day); use ISOWEEKNUM for ISO 8601 European-style weeks.
Used in
Syntax
WEEKNUM(date,[type])Examples
=WEEKNUM(DATE(1969,7,20),1) // => 30
=WEEKNUM("12/09/1948",2) // => 50
=WEEKNUM("6/14/2002") // => 24