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.
