Excel Week Number: Formulas, ISO Weeks, and Dates Explained

Formulas & functions · Updated November 19, 2026

In Excel, use WEEKNUM to return a date’s week number; for the internationally standardized Monday-starting system, use ISOWEEKNUM. The result depends on the week-numbering rule, so choose the one your reports or organization require rather than assuming every calendar counts weeks the same way.

What a week number means in Excel

A week number labels a date according to its position in a calendar year. Excel does not have just one definition of week 1: depending on the system, weeks may start on Sunday or Monday, and the first week may be defined differently. That is why the same date can have different week numbers under different rules.

Week numbers are useful for grouping orders, timesheets, production totals, appointments, and other dated records. They are not dates themselves, however. Week 12 alone does not identify a unique period: it could refer to week 12 in any year, and the start and end dates depend on the calendar convention. For reliable reporting, keep the original date and usually include the year alongside the week number.

Excel stores dates as serial values and calculates the week from the date value in the cell. A cell’s display format does not change the underlying date or the week-number calculation. If A2 contains a real Excel date, a formula can calculate its week even if the cell is displayed in a different date format.

Choose the week-numbering system

First check what your audience means by a week. A company calendar, government report, scheduling system, or customer specification may define the rule explicitly. When there is no stated convention, do not silently mix systems: label the rule in the workbook or report.

  • Sunday-starting week: Excel’s common U.S. convention. With this rule, week 1 contains January 1, and weeks begin on Sunday.
  • Monday-starting week: Weeks begin on Monday, while week 1 still contains January 1. This is a Monday-starting system, but it is not necessarily ISO week numbering.
  • ISO 8601 week: Weeks begin on Monday, and week 1 is the week containing the year’s first Thursday (equivalently, January 4). An ISO week-year can start in late December or end in early January of the adjacent calendar year.

The key distinction is not simply Sunday versus Monday. The rule for deciding which days belong to week 1 matters too. ISO dates near New Year are a common source of mismatches between spreadsheets and business systems.

Use WEEKNUM for standard week numbering

With the date in A2, enter this formula for the default Sunday-starting system:

=WEEKNUM(A2,1)

The second argument is called the return type. It selects the week-start convention. For a Monday-starting system where week 1 contains January 1, use this formula, again with the date in A2:

=WEEKNUM(A2,2)

For example, if A2 contains December 30, 2024, the Sunday-starting formula returns 53, and the Monday-starting formula also returns 53. The results happen to agree for that date; in other dates and years, the two conventions can differ. Specifying the return type makes the intended rule visible and avoids relying on the function’s default.

WEEKNUM also supports other return types for weeks that begin on different weekdays. For ordinary reporting, types 1 and 2 are the most commonly needed. Excel’s function help lists the full set of return types and their weekday starts. If a business has a custom calendar, confirm that the chosen return type matches its actual definition instead of inferring the rule from a sample date.

To calculate week numbers for a list, put the formula in the first result row and fill it down. In Microsoft 365 for Windows, select the formula cell and drag its fill handle down, or double-click the fill handle when an adjacent column contains continuous data. Excel adjusts A2 to A3, A4, and so on. You can then filter or sort by the result, but remember that sorting only by week number may combine records from different years.

Use ISOWEEKNUM for ISO weeks

With a real date in A2, use this formula to return its ISO week number:

=ISOWEEKNUM(A2)

For example, if A2 contains January 1, 2021, the result is 53. Under ISO rules, that Friday belongs to week 53 of the ISO week-year 2020. By contrast, WEEKNUM with return type 2 reports week 1 for that date, because that system makes the week containing January 1 week 1. These are different definitions, not a calculation error.

ISOWEEKNUM returns a number from 1 to 53. Some years have 53 ISO weeks; others have 52. It is available in modern Excel, including Microsoft 365. If a workbook must be opened in an older Excel version, check that version’s function support and test the file with the intended users rather than assuming every installation recognizes the function.

Do not substitute =WEEKNUM(A2,2) for =ISOWEEKNUM(A2) merely because both use Monday-starting weeks. They differ around the beginning and end of some calendar years because their rules for week 1 are not the same.

Pair the week number with the correct week-year

A week number by itself can be misleading at year boundaries. ISO week 1 can include dates in December, and ISO week 53 can include dates in January. If you group or export ISO weeks, use the ISO week-year, not necessarily the calendar year shown by YEAR for the date.

With the date in A2, this formula returns the ISO week-year by moving to the Thursday in the same ISO week and taking that date’s year:

=YEAR(A2-WEEKDAY(A2,2)+4)

For January 1, 2021 in A2, the formula returns 2020, while =ISOWEEKNUM(A2) returns 53. The pair is therefore ISO week-year 2020, week 53. For December 30, 2024, the ISO week number is 1 and the ISO week-year is 2025.

For a conventional Sunday- or Monday-starting WEEKNUM report, organizations often group using the calendar year and week number together, but confirm the intended treatment of weeks that cross New Year. If a label is needed, separate columns for year and week are often easier to sort and analyze than a text label. A label such as 202501 should not be created by simply joining a calendar year to an ISO week number unless the year is specifically the ISO week-year.

Check that Excel is receiving real dates

A date that looks correct on screen may actually be text imported from a file. In that case, date calculations can return an error or an unexpected result. Click the cell and inspect its contents and alignment, but do not rely on alignment alone: formatting can make text resemble a date. A quick check is to change a copy of the cell to General format; a real date usually displays as a serial number.

If you are entering a test date directly in a formula, with no source date cell involved, this formula creates December 30, 2024 as an actual date value:

=DATE(2024,12,30)

Using DATE avoids ambiguity between regional date strings such as 03/04/2024, which may be read as March 4 or April 3 depending on regional settings. For imported text dates, use Excel’s data-conversion tools or correct the source data, and verify a few converted dates before applying week formulas to a whole column.

In Microsoft 365 for Windows, you can change how a date is displayed with Home > Number Format. This changes presentation, not the date value used in the calculation. If an imported date is stored as text, changing its number format alone will not convert it into a real date.

Common problems and how to fix them

  • Unexpected week around New Year: Check whether the report expects ISO numbering, Sunday-starting weeks, or Monday-starting weeks with January 1 in week 1. Test dates from late December and early January.
  • A week number appears to repeat: Week numbers repeat every year. Include a year or week-year when sorting, grouping, or matching records across multiple years.
  • The result is an error: Check that the referenced cell contains a valid Excel date rather than text, and confirm that the formula references the intended column.
  • Different results on another computer: If the formula omits the return_type, the default convention may not match the workbook’s intended rule. State the return type explicitly, or use ISOWEEKNUM for ISO reporting.
  • Week numbers are stored as text: A formula may have been wrapped in a text-producing operation or the result column may have been imported as text. Use numeric week values when you need reliable sorting and arithmetic.

A useful quality check is to compare dates immediately before and after New Year with the calendar system your organization follows. For example, check December 30, December 31, January 1, and January 4. If those boundary dates agree with the published calendar or system you are matching, ordinary dates are much less likely to reveal a hidden convention mismatch.

Frequently Asked Questions

What is the Excel formula for a week number?
With the date in A2, use =WEEKNUM(A2,1) for Sunday-starting weeks or =WEEKNUM(A2,2) for Monday-starting weeks where week 1 contains January 1. Use =ISOWEEKNUM(A2) for ISO weeks.

Why does Excel show week 53?
Some calendar or ISO years contain 53 numbered weeks under their respective rules. A result of 53 can be valid, especially near year-end; check the selected system and the week-year before treating it as an error.

Is WEEKNUM with 2 the same as ISOWEEKNUM?
No. Both use Monday as the first weekday, but WEEKNUM with return type 2 assigns week 1 to the week containing January 1. ISO week 1 is the week containing the year’s first Thursday.

How do I show the week number in a cell?
Enter a week formula in a neighboring cell and fill it down the rows. Excel does not turn a date into a week number merely by applying a standard date display format; the week number is calculated with a function.

Does Excel’s week number depend on my computer’s region?
Use an explicit return type in WEEKNUM, or use ISOWEEKNUM, to make the intended rule clear in the formula. Regional settings can still affect how date text is interpreted when entered or imported, so use genuine date values and check ambiguous source dates.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.