Is a date in week 1, 2, or 3 of its month? Subtract the month’s starting week number from the date’s week number (plus one) to get the week-of-month — handy for schedules and “2nd Tuesday” rules.
The example
June 17, 2026 falls in week 3 of June.
| A | B | |
|---|---|---|
| 1 | Date | Week of month |
| 2 | 6/17/2026 | 3 |
The formula
Week number relative to the month start:
How it works
It’s a difference of week numbers:
WEEKNUM(A2)is the date’s week number within the year.WEEKNUM(first of month)is the week number where that month begins.- Subtract and add 1 — the result is the week within the month (1–6).
- Use a matching WEEKNUM return type in both (e.g. 2 for Monday-start) so the math lines up.
“Nth weekday” pairs with this. Combine week-of-month with the weekday to express rules like “the 2nd Tuesday” — or jump straight to the nth-weekday-of-month recipe to compute that date.
Try it: interactive demo
Pick a date; see its week of the month.
Variations
Simple day-based
By day number:
Monday-start weeks
Match return type 2:
Is it the last week?
Compare to month-end week.
Pitfalls & errors
Two WEEKNUM conventions. Use the same return-type argument in both calls, or the difference is off.
Week-of-month definitions vary. The ROUNDUP(DAY/7) version (days 1–7 = week 1) differs from the WEEKNUM version (calendar weeks). Pick the one your context means.
Real dates only.
Practice workbook
Frequently asked questions
How do I find the week of the month in Excel?
Is there a simpler version?
Why does my week-of-month look off by one?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class