Excel Function : ISOWEEKNUM

Download now!

Excel Function : ISOWEEKNUM


Date and time


Returns the number of the ISO week number of the year for a given date

Microsoft Excel Reference Page


Syntax and Description of the ISOWEEKNUM Excel Function

I am trying to use the ISOWEEKNUM() function in Microsoft Excel 2016. However, I can't figure out the syntax for this function. Here is the syntax given on the Microsoft Excel website. I have tried various ways of using this function, but I keep getting errors. For example, I have tried using the following syntax, but it does not work. =ISOWEEKNUM(A1:A7) Any help would be appreciated. A: According to the documentation you linked to, you need to specify the date, not a range of dates:


About ISOWEEKNUM Excel Function

The ISOWEEKNUM function returns the ISO 8601 week number of a date. The ISO 8601 week number is based on weeks starting on Monday. The first week of the year is the week that contains at least four days in the new year.