The ISOWEEKNUM function returns the week's week number as a function of the date given in Excel.
ISOWEEKNUM function: a brief
THE Isoweeknum function in the Excel inputs A date and returns the week number (Since 1 to 54) depending on ISO standards. In this system, the weeks begin MondayAnd week 1 is the first week of the year which includes a THURSDAY. You can find more information on ISO week's date Here on the official Wikipedia page: Date of ISO week.
Compatibility of functions:
THE Isoweeknum The function was introduced in 2013. All Excel versions published after 2013 Support this function.
|
Objective |
Value returned by function |
|---|---|
|
Aims to return the ISO number from the entry date. |
The ISOWEEKNUM function will return an ISO numerical value from the input date values. |
ISOWEEKNUM function: a syntax
=ISOWEEKNUM(date_value)
- Date_Value: An Excel date value valid in serial number or appropriate Date format.
THE Isoweeknum The function returns the week number from the date of entry based on ISO standards. According to this ISO standard, the weeks begin MondayAnd week 1 is given to the first week of the same year which included a THURSDAY.
Difference b / w Weeknum & ISOWEEKNUM function in Excel:
|
Function |
Description |
The system followed |
|---|---|---|
|
Weeknum function |
This function calculates the week's number from January 1 (week 1), and the week can start on Sunday or Monday depending on the type of return. |
Follows the American system. |
|
ISOWEEKNUM function |
This function calculates the weekly issues based on ISO standard, where the week begins on Monday. |
Follows the ISO 8601 standard and week 1 is the week with the first Thursday of the year. |
Basic example of the use of the isoweeknum function:
If you work in an office where employee reports must be Submit every week And you want to calculate the ISO week number For each date of submission to Gather and analyze weekly reports. Note: week to start MondayAccording to ISO 8601 standard.
|
Entry date |
ISOWEEKNUM result |
Formula used |
|---|---|---|
|
01-Jan-2024 |
1 |
= ISOWEEKNUM (B4) |
|
June 15-2024 |
3 |
= ISOWEEKNUM (B5) |
|
March 25-2024 |
13 |
= ISOWEEKNUM (B6) |
|
June 30-2024 |
26 |
= ISOWEEKNUM (B7) |
|
02-SEP-2024 |
36 |
= ISOWEEKNUM (B8) |
|
31-Dec-2024 |
1 |
= ISOWEEKNUM (B9) |
Example of the use of the isoweeknum function with other nested functions:
The formula below is used to identify the cell value contains a Excel date value or not.
=IF(AND(ISNUMBER(B4),B4<>""), ISOWEEKNUM(B4), "Invalid or Empty")
From the image above, you can see that the isoweeknum function:
- Returns the ISO week number for a valid entry date value value.
- Returns the “Invalid or empty“For”Empty cell value“&”Text value. “”
That's it. This tutorial is initially published on how to use the isoweeknum function in Excel?
