ISOWEEKNUM

Get ISO week number for a given date

Sponsored Link

ISOWEEKNUM

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.

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.

Sponsored Link

0 votes. 0 / 5