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

Taught hands-on in Level 3: Intermediate Lookups & Data Summaries · Dates & Times module

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

ArgumentRequired?What it does
serial_numberYesThe date.
return_typeOptional1 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)
AB
1Sale dateWeek
21/1/20261
31/4/20262
43/15/202612
=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)
AB
1DateWeek (Mon start)
23/15/202611
=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

Kyle Stott

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.