Practice free

ISOWEEKNUM function

ISOWEEKNUM returns the ISO 8601 week number, 1 to 53, where weeks start on Monday and week 1 contains the year's first Thursday. Use it when reports must match ISO calendars.

Example

Read it as a sentence: find the ISO week number of the date in F1. F1 is empty, which counts as day 0 of 1900, so the answer is 52.

Practice this in the app

Syntax

ISOWEEKNUM(date)

date (required)
The date to evaluate.

Returns: The ISO 8601 week number, 1 to 53.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ISOWEEKNUM(DATE(2026,1,1)) 1 Thursday Jan 1
=ISOWEEKNUM(DATE(2027,1,1)) 53 Friday Jan 1
=ISOWEEKNUM(DATE(2021,1,3)) 53 Sunday Jan 3
=ISOWEEKNUM(DATE(2026,12,31)) 53 Year end
=ISOWEEKNUM("1/9/2026") 2 Text date
=ISOWEEKNUM(Data!F1) 52 Blank
=ISOWEEKNUM("x") #VALUE! Bad date
=ISOWEEKNUM(-1) #NUM! Negative serial

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Early January days can belong to week 52 or 53 of the prior year, and late December to week 1 of the next.
  • WEEKNUM defaults to a different system, so the two often disagree.

Where it works

Excel
ISOWEEKNUM arrived in Excel 2013. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Date and time functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .