ISOWEEKNUM Function in Google Sheets

Find the ISO week number for a given date using the ISOWEEKNUM function.

ISOWEEKNUM Function

The ISOWEEKNUM function in Google Sheets returns the ISO week number for a given date.

Syntax

ISOWEEKNUM(date)
  • date: The date for which to find the ISO week number.

Examples

  1. ISO Week Number for a Specific Date

Find the ISO week number for 2024-03-15:

=ISOWEEKNUM("2024-03-15")
  1. ISO Week Number for Current Date

Get the ISO week number for today’s date:

=ISOWEEKNUM(TODAY())

Notes

  • Follows the ISO 8601 standard where the week starts on Monday.
  • Week 1 is the week with the year’s first Thursday.
  • WEEKNUM: Returns the week number based on different starting days.