WEEKNUM

Returns a number representing the week of the year where the provided date falls.

Sample Usage

WEEKNUM(DATE(1969, 7, 20), 1)

WEEKNUM("12/09/1948", 2)

WEEKNUM("6/14/2002")

Syntax

WEEKNUM(date, [type])

  • date - The date for which to determine the week number. Must be a reference to a cell containing a date, a function returning a date type, or a number.
  • type - [ OPTIONAL - default is 1 ] - A number representing the day that a week starts on as well as the system used for determining the first week of the year (1=Sunday, 2=Monday).

Notes

  • When inputting the date, it is best to use the DATE function, as text values may return errors.
  • Behind the scenes, there are two week numbering "systems" used for this function:
    • System 1 - The first week of the year is considered to be the week containing January 1, which is numbered week 1.
    • System 2 - The first week of the year is considered to be the week containing the first Thursday of the year, which is numbered as week 1. System 2 is the approach specified in ISO 8601, also known as the European system for numbering weeks.
  • For each type, the start day and end day of a week are defined as follows when counting week numbers:
    type Day week begins on Day week ends on System
    1 or omitted Sunday Saturday 1
    2 Monday Sunday 1
    11 Monday Sunday 1
    12 Tuesday Monday 1
    13 Wednesday Tuesday 1
    14 Thursday Wednesday 1
    15 Friday Thursday 1
    16 Saturday Friday 1
    17 Sunday Saturday 1
    21 Monday Sunday 2

See Also

WEEKDAY: Returns a number representing the day of the week of the date provided.

DAYS360: Returns the difference between two days based on the 360-day year used in some financial interest calculations.

DATE: Converts a year, month, and day into a date.

DATEVALUE: Converts a provided date string in a known format to a date value.

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false