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

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 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 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 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 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 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 6

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

Good luck!

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

YEAR - The function for the value is the year of a numeric expression in Excel
year: the function returns the year of any date value, the year value is an integer between 1900 and 9999.
TODAY function - The function returns the current date value in the format in Excel
today function - the function returns the current date value in the format in excel. the today () function does not automatically update, but requires setting changes to control.
NETWORKDAYS.INTL function - The function returns the number of whole working days between 2 dates, specifying weekends in Excel
networkdays.intl: the function returns the number of whole working days between two dates by using a parameter that determines the number of weekends and which day of the week. syntax: networkdays.intl (start_date, end_date, [weekend], [holidays])
COUPNUM function - The function returns the number of interest payments on a security in Excel
in the process of investing in securities, paying special interest is very important. it helps you calculate and plan a reasonable calculation and investment. the following article details the coupnum function - the function returns the number of interest payments of securities in excel.
DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
days360 function: the function performs the calculation of the number of days between 2 days, based on 360 days year (from 12 months, 30 days per month). useful function in calculating payments in the accounting system based on twelve months 30 days. syntax: days (start_date, end_date, [m
PERMUT function - The function returns the number of permutations of a given number of objects in Excel
permut function: the function returns the number of permutations of a given object. permutations are subsets of values where the position and number of elements in permutations are different. syntax: permut (number, number_chosen)
SQL Server YEAR function
sql server's year function returns a 4-digit integer that is the year value in the timestamp passed.
RANK.AVG function - The function returns the rank of a number in a list of numbers in Excel
rank.avg function: the function returns the rank of a number in a list of numbers whose size is in correlation with other values. if multiple values have the same rank -> the function returns the average rank. support functions from execl 2010 version and above
DAYS function, how to use the function to calculate the number of days between two time points in Excel
the days function in excel returns the results between two different timelines.
How to separate the date, month, and year columns into 3 different columns in Excel
to separate the date, month and year in excel into separate values, we can do it with simple functions on excel.

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

You should read it

May be interested

Office information