The ISOWEKNUM number is the week number for the year based on the date specified in Excel.
ISOWEKNUM Job: Glory
the Isoweknum Job in Excel inputs date And restore Week number (from 1 to 54) Based on ISO standards. In this system, weeks begin MondayAnd Week 1 he First week From the year that includes a Thursday. You can find more information about ISO week Here on the official Wikipedia page: ISO week.
Job compatibility:
the Isoweknum The job was presented in 2013. everyone Excel versions were released after 2013 Support this job.
|
objective |
The value that is returned by the job |
|---|---|
|
It aims to repeat ISO number from the entry date. |
The ISOWEKNUM function will restore ISO numerical values from the entry date values. |
Isoweknum function: Building a sentence
=ISOWEEKNUM(date_value)
- Date_value: The value of the date of excellence is valid in pin number Or suitable History coordination.
the Isoweknum Return function Week number From the date of entry based on ISO standards. According to this ISO standard, weeks begin MondayAnd Week 1 It is presented to the first week of the same year that includes a Thursday.
Difference b/w
|
job |
a description |
Follow the system |
|---|---|---|
|
Weeknum function |
This job is calculated number week that starts from January 1 (week 1), and the week can start on Sunday or Monday based on the type of return. |
It follows the United States system. |
|
Isoweknum function |
This job is calculated for the week’s numbers based on the ISO standard, as it starts on Monday. |
It follows the ISO 8601 standard and the first week is the week with the first Thursday of the year. |
The primary example of the use of Isoweknum function:
If you are working in an office where the employee’s reports should be Happening send And you want an account ISO week number Each date has to be submitted to Group and analysis Weekly reports. Note: A week begins MondayAccording to ISO 8601 standards.
|
Date of input |
Isoweknum |
The formula used |
|---|---|---|
|
01-jan-2024 |
1 |
= isweeknum (B4) |
|
January 15-2024 |
3 |
= isweeknum (B5) |
|
March 25 -2024 |
13 |
= isweeknum (B6) |
|
June 30 -2024 |
26 |
= isweeknum (B7) |
|
02 Sep-2024 |
36 |
= isweeknum (B8) |
|
December 31, 2014 |
1 |
= isweeknum (B9) |
An example of the use of Isoweknum function with other overlapping functions:
The formula is used below to determine the value of the cell contains valid The value of the date of excellence Or not.
=IF(AND(ISNUMBER(B4),B4<>""), ISOWEEKNUM(B4), "Invalid or Empty")
From the image above, you can see that ISOWEKNUM:
- The ISO week number is restored for the valid entry date.
- Return “Uninterrupted“Both”The empty cell value&The value of the text“
That’s it. This tutorial is originally published on how to use the Isoweknum function in Excel?
