ISOWEEKNUM
Formula Explanation
Returns the ISO week number for a given date in the year.
ISO week numbers are a way of representing the week of the year according to international standards set by the International Organization for Standardization (ISO).
ISO week numbers divide the year into 52 or 53 weeks, with the first week starting on a Monday and containing the first Thursday of the year. This means that the first week of a year may start in the last few days of the previous year and extend into the first few days of the next year.
ISO week numbers are primarily used for statistical and calculation purposes, especially in business and production fields, to determine the date range for a specific week.
Formula Syntax
ISOWEEKNUM(date / column number)
The ISOWEEKNUM function syntax has the following arguments:
- Date: Required. The date is a date-time code used in Excel date and time calculations.
Usage Example
Calculate the ISO week number for the values in column DB2 and write the results into column DB3.
DB3 = ISOWEEKNUM(DB2)
