ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel

ISOWEEKNUM function: The function returns the ordinal number of the year of the week that contains the given date. Syntax: ISOWEEKNUM (date)

The following article introduces you to the ISOWEEKNUM function - one of the functions in the date and time group function is very popular in Excel.

ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 1ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 1

Description: The function returns the ordinal number in the year of the week that contains the given date.

Syntax : ISOWEEKNUM (date)

Where: date is the date to determine the week number in the year that contains that day, a required parameter.

Attention:

- Excel stores dates in a consecutive number format to facilitate the calculation process.

- The date argument is not a valid number -> the function returns the #NUM! Error value

- The date argument is not a valid date -> the function returns the #VALUE! Error value

For example:

Find the week number for the year corresponding to the date in the table below:

ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 2ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 2

- In the cell to calculate enter the formula: = ISOWEEKNUM (E7).

ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 3ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 3

- Press Enter -> 12/25/16 located at week 51 of the year:

ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 4ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 5ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 5

- Where the date value is invalid -> the function returns the error value #VALUE!

ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 6ISOWEEKNUM function - The function returns the ordinal number of the year of the week that contains the given date in Excel Picture 6

Above are instructions and some specific examples when using the ISOWEEKNUM function .

Good luck!

4 ★ | 1 Vote