Knowledge base / Excel
WEEKNUM and ISOWEEKNUM in Excel: choosing the right week
I explain why a Monday start does not establish ISO numbering and show how to avoid week-number and week-year mistakes at the year boundary.

A weekly report needs another piece of information: which rule assigns week numbers? Starting a week on Monday does not settle the numbering system. In Excel, return types 11 and 21 both use Monday, but identify the first week differently. That distinction becomes particularly visible around the end of a year.
The English function is WEEKNUM; its correct Polish name is NUM.TYG. The older Polish entry incorrectly used NUMER.TYGODNIA. The page keeps its existing address while the revised examples use the documented function names.
Syntax and the choice of system
Microsoft’s WEEKNUM documentation distinguishes a system whose first week contains January 1 from the ISO system whose first week contains the year’s first Thursday. The syntax is:
=WEEKNUM(serial_number,[return_type])
The first argument is a date. The second selects the numbering rule. Square brackets identify an optional argument in the syntax description; do not type them into an actual formula. The default return type is 1. These English examples use commas, although your configuration may require another separator.
I state the return type explicitly in a report, even when using the default. It helps the person maintaining the file identify the chosen rule. A short explicit argument can prevent a much longer discussion about why two reports disagree.
| Return type | Week starts on | Rule for week one |
|---|---|---|
| 1 or omitted | Sunday | Contains January 1 |
| 2 or 11 | Monday | Contains January 1 |
| 12, 13, 14 | Tuesday, Wednesday, Thursday | Contains January 1 |
| 15, 16, 17 | Friday, Saturday, Sunday | Contains January 1 |
| 21 | Monday | Contains the year’s first Thursday, ISO |
Express an ISO requirement directly
For an ISO week number, I can use the separate ISOWEEKNUM function:
=ISOWEEKNUM(A2)
For the same valid input date, the following also returns the ISO week number:
=WEEKNUM(A2,21)
I choose the form that makes the workbook easiest for its maintainers to understand. Microsoft’s documentation for both functions covers Excel 2016, 2019, 2021, 2024 and Microsoft 365. ISO numbering does not need to be described as a feature exclusive to the newest subscription.
I would not describe return types 2 and 11 as ISO merely because they start on Monday. Establish the report’s convention before choosing the formula. An organization using a separate fiscal calendar might need a different mapping altogether. A familiar-looking number is insufficient evidence that a function matches that calendar.
Use a boundary example that reveals the difference
Enter =DATE(2021,1,1) in A2 and =DATE(2021,1,4) in A3. This is a synthetic boundary example. The results follow from the documented rules and calendar, without running formulas.
| Date | =WEEKNUM(A2,2) |
=WEEKNUM(A2,11) |
=WEEKNUM(A2,21) |
=ISOWEEKNUM(A2) |
|---|---|---|---|---|
| 2021-01-01 | 1 | 1 | 53 | 53 |
| 2021-01-04, formulas referencing A3 | 2 | 2 | 1 | 1 |
January 1, 2021 was a Friday. Under system one, containing January 1 makes that week number 1. Monday, January 4 begins the next week in that system, so the result is 2. Return types 2 and 11 behave identically in this example.
The first Thursday of 2021 falls on January 7. Its ISO week begins on January 4, which therefore has week number 1. Friday, January 1 still belongs to the final ISO week of 2020, number 53. A rule that only specifies Monday as the first day does not capture this distinction.

Pair a week number with the appropriate year
For January 1, 2021, pairing calendar year 2021 with ISO week 53 can mislead a reader. The ISO week-year is 2020 in that case. An ISO report needs a year assigned under the same convention as its week number, rather than automatically taking the calendar year from the input date.
I would retain a week-start date or use an agreed calendar table containing the week-year and number. This makes it possible to inspect which dates belong to a group. Across several years, grouping only by week 1 combines multiple periods. A useful period key needs enough information to distinguish them.
For an organizational calendar, ask about partial weeks, the year boundary and the beginning of the reporting period. Do not select a rule merely because its numbers look familiar in the current month. Two systems can agree for an extended period and diverge in the boundary cases nobody inspected.
Input dates and errors
The examples use DATE instead of text whose interpretation depends on locale. When importing data, I check that the column contains valid Excel dates. Missing and erroneous inputs need attention before grouping; the formula cannot establish the business meaning of a missing date.
Microsoft documents #NUM! for an unsupported return type or a date outside the applicable date-system range. A misspelled function name produces a different kind of problem, commonly shown as #NAME? in English Excel. Changing a result cell’s display format does not correct the underlying choice of function or argument.
When another report disagrees, I first compare the input date, numbering rule and year assigned to the week. Then I inspect aggregation. This helps distinguish a calendar mismatch from a data issue or duplicated records. Without that order, it is easy to investigate the wrong part of a calculation.
An exercise before using a large dataset
Compare December 31, 2020, January 1, 2021 and January 4, 2021 in a small table. Add a column using return type 11 and another using ISOWEEKNUM. The ISO results should be 53, 53, 1; the first two dates belong to ISO week-year 2020. Explain the rule before moving to a larger table.
Finally, write the complete period definition beside the report: first day of the week, rule for week one and assignment of the year. A reader should understand it without inspecting the formula. If you need the weekday instead, see WEEKDAY. For the day of the month, use DAY.
Key takeaways
What is WEEKNUM called in Polish Excel?
NUM.TYG. The older Polish entry incorrectly used NUMER.TYGODNIA. The separate ISO week-number function is ISO.NUM.TYG.
Does WEEKNUM return type 11 use ISO numbering?
No. It begins weeks on Monday but assigns week one to the week containing January 1. Use return type 21 or ISOWEEKNUM for ISO numbering.
Why can January 1 belong to the previous ISO year?
The first ISO week contains the year’s first Thursday. January 1, 2021 belongs to ISO week 53 of 2020; week one begins on January 4.
AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.
