ISOWEEKNUM

Find the ISO week number of a year for a given date in Excel
Returns the number of the ISO week number of the year for a given date

Rational

Find the ISO week number of a year for a given date.

Description

The Excel ISOWEEKNUM function return ISO week number considering a week begins on Monday. Example; to find ISO week number for any date (09-03-2017), use = ISOWEEKNUM(date) that returns 10.

Under ISO week date system, the first week starts on Monday of the calendar year with a Thursday.

Syntax

=ISOWEEKNUM(date)

Parameters

date – A valid argument of date or serial number recognized by Excel

Return Value

An Integer between 1 and 52 or 53 representing week number of a specific date as per ISO standard.

Key Notes

  • Excel ISOWEEKNUM function categorize dates by the week number of the year based on ISO date standards.
  • Make sure to use the date as a cell reference rather than inputting it manually.
  • Use the WEEKNUM function to returns the normal week number in the year.

Keep Reading Similar Functions:

Return only the day value of a date in Excel

DAY

The DAY function returns an integer value that represents the day element of a date. I.e.; to extract day component, use =DAY(“08-08-2017”) that returns ‘8’.

Read More »
Get the week number of a date in Excel

WEEKNUM

The WEEKNUM function finds the week number of date and week start day, i.e., week starting from Monday (05-06-2018-C7), use =WEEKNUM(B7,2) that returns ‘23’.

Read More »
Converts a serial number of a day in the week in Excel

WEEKDAY

The WEEKDAY function returns an integer between 1 and 7 the corresponds specific day of a week. Example; (07-04-2018: Cell-B6), use =WEEKDAY(B6,2) returns ‘6’.

Read More »