Excel ISOWEEKNUM Function
Summary
The Excel ISOWEEKNUM function takes a date and returns a week number (1-54) that follows ISO standards, where weeks begin on Monday and week number 1 is assigned to the first week in a year that contains a Thursday.
Purpose
Get ISO week number for a given date
Return value
A number between 1 and 54.
Syntax
=ISOWEEKNUM (date)
Arguments
- date - A valid Excel date in serial number format.
Version
Usage notes
The ISOWEEKNUM function returns a week number based on ISO standards. Under this standard, weeks begin on Monday and the week number 1 is assigned to the first week in a year that contains a Thursday.
ISOWEEKNUM formula examples
The WEEKNUM function takes a date and returns a week number (1-54) that corresponds to the week of year. The WEEKNUM function starts counting with the week that contains January 1. WEEKNUM takes two arguments: a date,...
Related functions
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.
