Excel Function : ISOWEEKNUM

Download now!

Excel Function : ISOWEEKNUM

Category

Date and time

Description

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

Microsoft Excel Reference Page

https://support.office.com/en-us/article/ISOWEEKNUM-function-1c2d0afe-d25b-4ab1-8894-8d0520e90e0e

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.