Question 1

What is an ISO week number?

Accepted Answer

An ISO week number is a standardized way of numbering the weeks of the year according to the ISO 8601 international standard, where week 1 is defined as the week containing the first Thursday of January. Weeks run from Monday to Sunday, and the year can contain either 52 or 53 weeks depending on how the calendar falls. ISO week numbers are widely used in European business, logistics, and manufacturing scheduling to create consistent week-based reporting periods.

Question 2

Why is week 1 not always the week containing January 1?

Accepted Answer

Under the ISO 8601 definition, week 1 is the week that contains the first Thursday of the year, which means January 1 can fall in week 52 or 53 of the previous year if it falls on a Friday, Saturday, or Sunday. For example, if January 1 is a Saturday, it belongs to the last week of the previous year, and week 1 of the new year begins on the following Monday, January 3. This rule ensures that each ISO week always starts on a Monday and contains at least four days of the new year.

Question 3

Does ISO week 1 always start on a Monday?

Accepted Answer

Yes, every ISO week begins on Monday and ends on Sunday, which is one of the defining principles of the ISO 8601 week date system. This is different from the US convention where weeks are often considered to start on Sunday. The Monday start is standard across Europe, international business, and most programming libraries that implement ISO week numbers.

Question 4

How many weeks are in a year?

Accepted Answer

Most years contain 52 ISO weeks, but some years contain 53 weeks — these are called long years or leap weeks in the ISO calendar. A year has 53 ISO weeks if January 1 or December 31 falls on a Thursday, or if January 1 falls on a Wednesday in a leap year. On average, about 71% of years have 52 weeks and 29% have 53 weeks under the ISO 8601 system.

Question 5

Does week 53 really exist, and when does it occur?

Accepted Answer

Yes, week 53 is real and occurs in years where the ISO 8601 rules produce 53 complete Monday-to-Sunday weeks. This happens when January 1 falls on a Thursday (or on a Wednesday in a leap year), because those configurations leave enough days at the end of December to form a full 53rd week. Recent examples of 53-week years include 2015, 2020, and 2026.

Question 6

What is the difference between US and ISO week numbering?

Accepted Answer

The key difference is that ISO week numbering starts on Monday and defines week 1 as the week containing the first Thursday of January, while the US system typically starts weeks on Sunday and defines week 1 as the week containing January 1. This means the US and ISO week numbers for the same date can differ by one, and dates in late December or early January may belong to different week-year combinations in the two systems. Excel's WEEKNUM function defaults to the US convention, while ISOWEEKNUM uses the ISO standard.

Question 7

How do I find the week number for a date in Excel?

Accepted Answer

Excel offers two functions for week numbers: WEEKNUM(date, return_type) calculates the week number using various start-day conventions (return_type 2 starts weeks on Monday in the US style), and ISOWEEKNUM(date) always returns the ISO 8601 week number with weeks starting on Monday. For example, =ISOWEEKNUM(TODAY()) returns the current ISO week number. Use ISOWEEKNUM when you need results consistent with European partners or international standards.

Question 8

What are fiscal weeks and how do they differ from calendar weeks?

Accepted Answer

Fiscal weeks are defined by an organization's financial calendar, which may start on a day other than Monday and may begin the fiscal year on a date other than January 1. For example, a retailer might use a 4-4-5 fiscal calendar where months are grouped into periods of 4, 4, and 5 weeks to ensure comparable reporting periods each quarter. Fiscal week numbers therefore do not align with ISO calendar week numbers, and companies must maintain their own fiscal week lookup tables for accurate financial reporting.

date	week Number	week Year	week Start	week End	note
2026-01-01	1	2026	2025-12-29	2026-01-04	Week 1 of 2026 starts in Dec 2025
2026-05-26	22	2026	2026-05-25	2026-05-31	Current week (May 26, 2026)
2026-12-31	53	2026	2026-12-28	2027-01-03	2026 has 53 ISO weeks
2025-01-01	1	2025	2024-12-30	2025-01-05	Week 1 of 2025 starts in Dec 2024
2026-08-15	33	2026	2026-08-10	2026-08-16	India Independence Day week

📋 Calendar Week Number — 🇩🇪 Germany

How to Use the Calendar Week Number in Germany

Real-World Examples for Germany

Frequently Asked Questions

What is an ISO week number?

Why is week 1 not always the week containing January 1?

Does ISO week 1 always start on a Monday?

How many weeks are in a year?

Does week 53 really exist, and when does it occur?

What is the difference between US and ISO week numbering?

How do I find the week number for a date in Excel?

What are fiscal weeks and how do they differ from calendar weeks?

📋 Calendar Week Number — 🇩🇪 Germany

How to Use the Calendar Week Number in Germany

Real-World Examples for Germany

Frequently Asked Questions

What is an ISO week number?+

Why is week 1 not always the week containing January 1?+

Does ISO week 1 always start on a Monday?+

How many weeks are in a year?+

Does week 53 really exist, and when does it occur?+

What is the difference between US and ISO week numbering?+

How do I find the week number for a date in Excel?+

What are fiscal weeks and how do they differ from calendar weeks?+

More Free Date & Time Tools

What is an ISO week number?

Why is week 1 not always the week containing January 1?

Does ISO week 1 always start on a Monday?

How many weeks are in a year?

Does week 53 really exist, and when does it occur?

What is the difference between US and ISO week numbering?

How do I find the week number for a date in Excel?

What are fiscal weeks and how do they differ from calendar weeks?