What week number is it? ISO and US week numbers explained

By Huzaifa Awais ·

Today is ISO week 45 and US week 46 (8 November 2026). Europe and most software use the ISO number; the US and Excel’s WEEKNUM use the other.

The two systems disagree for part of almost every year, which is why the same date can be “week 45” in one calendar and “week 46” in another. This guide explains both, and gives you the formula and code. To check any date, use the free week number tool.

What is the ISO week number?

The ISO week number comes from ISO 8601. Weeks start on Monday, and week 1 is the week that contains the year’s first Thursday.

The rules

  • Every week runs Monday to Sunday.
  • Week 1 contains the first Thursday of January. That is the same as the week that contains 4 January.
  • Every week belongs to exactly one year, so no week is ever split.
  • The first days of January can belong to the last week of the previous year, and the last days of December can belong to week 1 of the next year.

Who uses it

Most of Europe, many Asian countries, payroll and logistics software, and the date functions in most programming languages. If someone writes “2026-W45”, that is an ISO week.

How are US week numbers different?

US week numbers start on Sunday, and week 1 is whatever week contains 1 January, even if it is only one day long.

ISO 8601US system
Week starts onMondaySunday
Week 1 isThe week with the first ThursdayThe week with 1 January
Weeks in a year52 or 5353, or 54 in rare years
Excel function=ISOWEEKNUM(A1)=WEEKNUM(A1,1)

Because the US system starts a new week every Sunday and counts the partial first week, its number is often one higher than the ISO number. 8 November 2026 is a Sunday, so it is ISO week 45 but US week 46.

How many weeks are in a year?

An ISO year has 52 or 53 weeks. It has 53 when it starts on a Thursday, or when it is a leap year that starts on a Wednesday.

Years with 53 ISO weeks

2026 starts on a Thursday, so it has 53 weeks, and 31 December 2026 is in week 53. The previous one was 2020, and the next is 2032.

Can a US year have 54 weeks?

Yes. When a leap year starts on a Saturday, 1 January is alone in week 1 and 31 December is alone in week 54. 2028 is the next year this happens.

How do you calculate the ISO week number?

Use week = floor((dayOfYear − weekday + 10) / 7), with Monday as 1 and Sunday as 7, then fix the edge cases at the start and end of the year.

Worked example: 8 November 2026

  1. Day of the year: 8 November is day 312.
  2. Weekday: Sunday, so 7.
  3. Week: floor((312 − 7 + 10) / 7) = floor(315 / 7) = 45.

The two edge cases

  • A result of 0 means the date is in the last week of the previous year.
  • A result of 53 in a year that has only 52 weeks means the date is in week 1 of the next year.

The US week formula

For the US system, use week = floor((dayOfYear + w − 1) / 7) + 1, where w is the weekday of 1 January counted from Sunday as 0. In 2026, 1 January was a Thursday, so w = 4 and 8 November gives floor(315 / 7) + 1 = 46.

How do I get the week number in Excel, Python, PHP or JavaScript?

Most tools have it built in: =ISOWEEKNUM() in Excel, isocalendar() in Python and date('W') in PHP. JavaScript needs a short function.

Excel and Google Sheets

=ISOWEEKNUM(A1)     ISO week
=WEEKNUM(A1, 1)     US week, starting Sunday
=WEEKNUM(A1, 21)    ISO week in older Excel versions

Python

from datetime import date
date(2026, 11, 8).isocalendar().week   # 45

PHP

echo date('W', strtotime('2026-11-08'));   // 45
echo date('o-\WW');                        // ISO year and week, such as 2026-W45

JavaScript

function isoWeek(d) {
  const t = new Date(Date.UTC(d.getFullYear(), d.getMonth(), d.getDate()));
  const day = t.getUTCDay() || 7;          // Monday 1 ... Sunday 7
  t.setUTCDate(t.getUTCDate() + 4 - day);  // move to that week's Thursday
  const yearStart = Date.UTC(t.getUTCFullYear(), 0, 1);
  return Math.ceil(((t - yearStart) / 86400000 + 1) / 7);
}
isoWeek(new Date(2026, 10, 8));   // 45

SQL

SELECT WEEK('2026-11-08', 3);       -- MySQL, ISO week: 45
SELECT EXTRACT(WEEK FROM DATE '2026-11-08');   -- PostgreSQL, ISO week: 45

Watch out for the year. On 1 January 2027 the ISO week is 53 of 2026, so pair the ISO week with the ISO year (o in PHP, isocalendar().year in Python), not the calendar year.

Which week number should I use?

Use ISO week numbers for anything shared across countries or stored in software. Use US week numbers only when a US team or report already expects them.

When you send a date to someone in another country, write the date itself, or say which system you mean, such as “ISO week 45”. That one word avoids a whole week of confusion.

Check any date for free

The week number tool shows today’s ISO week and the week for any date you pick, right in your browser. For more date maths, see the free time and date tools.