WEEKNUM Function
Returns the week of the year a date falls in.
Category
Date & Time
Available in
All versions, Microsoft 365
Returns
A week number from 1 to 54
Overview
WEEKNUM numbers the weeks of the year. Week 1 always contains January 1, and by default each new week starts on a Sunday.
Use return_type 2 for weeks starting on Monday, or 21 for the ISO system used across Europe (the same as ISOWEEKNUM).
Syntax
=WEEKNUM(serial_number, [return_type])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| serial_number | Yes | The date. |
| return_type | Optional | 1 or omitted: weeks start Sunday. 2: weeks start Monday. 11–17: start Monday … Sunday. 21: ISO weeks. |
Examples
Example 1 — Week numbers for a sales log
January 1, 2026 is a Thursday, so week 2 starts on Sunday, January 4.
B2fx=WEEKNUM(A2)
| A | B | |
|---|---|---|
| 1 | Sale date | Week |
| 2 | 1/1/2026 | 1 |
| 3 | 1/4/2026 | 2 |
| 4 | 3/15/2026 | 12 |
=WEEKNUM(A2) Explain
Example 2 — Weeks starting on Monday
The same Sunday, March 15, belongs to the previous Monday-to-Sunday week.
B2fx=WEEKNUM(A2,2)
| A | B | |
|---|---|---|
| 1 | Date | Week (Mon start) |
| 2 | 3/15/2026 | 11 |
=WEEKNUM(A2,2) Explain
Common mistakes
- Week numbers don't match a European colleague's. They use ISO weeks, where week 1 is the week with the first Thursday. Use return_type 21 or ISOWEEKNUM.
Notes
- Related functions: ISOWEEKNUM, WEEKDAY.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.