Menu
EXCEL ISOWEEKNUM FUNCTION
Excel ISOWEEKNUM Function Introduction
The ISOWEEKNUM Function in Excel is a Date & Time Function that determines the ISO week number for the provided date value (e.g., week number 37 of 52 weeks in a year).
Description of Excel ISOWEEKNUM Function
Syntax :
=ISOWEEKNUM(date)
Parameters :
Where date is a mandatory argument. Excel uses a serial date format to store dates. It reflects the days beginning on January 1, 1900. So the serial number 1 would be January 1, 1900, and the serial number 39814 would be January 1, 2009, as it is 39814 days after January 1, 1900.
This method will return a number between 1 and 52, indicating the week in which the date occurs.
Step By Step Guide of ISOWEEKNUM Function
Example :
Assume the date is today, November 21, 2021. If we want to know which week of the year it is, we may use the ISOWEEKNUM function as follows:
Key Points
- #NUM! error – This occurs when the date parameter is not a valid number.
- #VALUE! error – Occurs when the date argument is not of the correct type.
- The ISOWEEKNUM function computes the week number based on the European ISO standard ISO8601:2000.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
