Skip to main content

WEEKNUM

Definition of 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:
     

    typeDay week begins onDay week ends onSystem
    1 or omittedSundaySaturday1
    2MondaySunday1
    11MondaySunday1
    12TuesdayMonday1
    13WednesdayTuesday1
    14ThursdayWednesday1
    15FridayThursday1
    16SaturdayFriday1
    17SundaySaturday1
    21MondaySunday2

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 provided year, month, and day into a date.

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

In order to use the WEEKNUM formula, start with your edited Excellentable

Then type in the WEEKNUM Formula in the area you would like to display the outcome:

By adding the values you would like to calculate, Excellentable generates the outcome:

Error.

User does not have sufficient privileges to access this Content
Learn More

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.