WEEKNUM Function – Google Sheets

 

The WEEKNUM function accepts a date and returns the week number (1 through 54) of that date. The date must be in a valid format, so you have to use the DATE function, wrap it in quotes, or use a cell reference to a cell containing a date.

If your days, months, and years are in different cells, use the DATE function to combine them.

Syntax

=WEEKNUM(date,[type])

  • date – The date for which you want the week number. This is required.
  • [type] – Optional specification of which day is the first day of the week. And, which week is the first week of the year.
    • 1 (or not specified) – Week begins on Sunday
    • 2  – Week begins on Monday
    • 11 – Week begins on Monday (same as #2)
    • 12 – Week begins on Tuesday
    • 13 – Week begins on Wednesday
    • 14 – Week begins on Thursday
    • 15 – Week begins on Friday
    • 16 – Week begins on Saturday
    • 17 – Week begins on Sunday
    • 21 – Week begins on Monday and the week containing the first Thursday of the year is numbered week 1. See ISOWEEKNUM for more.

Related functions

DATE – Takes separate year, month, and day values and returns them as a date

DATEVALUE – Returns the serial value of a date

ISOWEEKNUM – Returns the ISO day of the week. Similar to WEEKNUM.

Errors

#NUM – The inputs are numbers but are not valid dates for the date input or the type input is out of range. This could happen if you use a negative number for the date or a number for type that is not one of the preset options (i.e. 1, 2, 11).

#VALUE! – The inputs are something that doesn’t convert to a number such as “The other day” or “Yester-yester-day”.

Examples

 Live examples in Sheets

Go to this spreadsheet for the examples of the WEEKNUM function shown above that you can study and use anywhere you would like.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>