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.
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:
- In the cell to calculate enter the formula: = ISOWEEKNUM (E7).
- Press Enter -> 12/25/16 located at week 51 of the year:
- Similarly copying the formula for the remaining values results:
- Where the date value is invalid -> the function returns the error value #VALUE!
Above are instructions and some specific examples when using the ISOWEEKNUM function .
Good luck!
You should read it
- WEEKNUM function - The function returns the week number of the year in Excel
- YEAR - The function returns the year corresponding to a date in Excel
- DAY function - The function returns the date value of a specific date in Excel
- The DAY function - The function returns the day of the day, month and year in Excel
- NOW function - The function returns the current date and time in Excel
- The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
- DATE function - The date function in Excel
- SQL Server YEAR function
- WEEKDAY function - The function returns the weekday of a corresponding date in Excel
- The WORKDAY.INTL function - The function returns a date before or after the date starting with a custom weekend in Excel
- TODAY function - The function returns the current date value in the format in Excel
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
Maybe you are interested
How to Fix Clipboard History Error in Windows 11 Latest Update
4 Ways to update Win 11 Driver, quick update tips
Microsoft makes major improvements to Windows Update, updates will be installed much faster
WinRAR 6.10 beta update fixes Windows 11 context menu bug
Windows updates constantly, why?
How to update graphics drivers in Windows 10 and 11