ISOWEEKNUM Function – Google Sheets

The ISOWEEKNUM function accepts a date and returns the ISO 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.

An ISO week starts on Monday. The first week of the year is the first week containing a Thursday in that year.

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

Syntax

=ISOWEEKNUM(date)

  • date – The date for which you want the ISO week number. This is required.

Related functions

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

DATEVALUE – Returns the serial value of a date

WEEKNUM – Returns the number of a given week

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.

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

Examples

Example 1 – Plain and Simple

Formula Result
=ISOWEEKNUM(“March 1,2017”) 9

Example 2 – ISOWEEKNUM with DATE function

Formula Result
=ISOWEEKNUM(DATE(2019,11,7)) 45

 

 Live examples in Sheets

Go to this spreadsheet for the examples of the ISOWEEKNUM 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>