“When’s the next Monday?” — for scheduling deliveries, billing cycles, or follow-ups. A short WEEKDAY + MOD formula jumps from any date to the next occurrence of a chosen weekday.
+ 6, 7) + 1 tweaks to force “strictly after.”)
The example
The next Monday on or after each date.
| A | B | |
|---|---|---|
| 1 | From | Next Monday |
| 2 | 6/17/2026 (Wed) | 6/22/2026 |
| 3 | 6/22/2026 (Mon) | 6/22/2026 |
The formula
Next Monday (DOW 2) on or after A2:
How it works
MOD does the “days until” math:
WEEKDAY(A2)is the start date’s day number.DOW - WEEKDAY(A2) + 7, wrapped inMOD(…, 7), gives the number of days forward to the next target weekday (0 if today already is that day).- Adding that to
A2lands on the next occurrence — here, the following Monday. - This version returns today if it already matches. To always move strictly after, use
=A2 + 7 - MOD(WEEKDAY(A2) - DOW + 6, 7).
Try it: interactive demo
Pick a start date and target weekday.
Variations
Strictly after (never today)
Always advance at least one day:
Next weekday (any business day)
Skip to the next Mon–Fri:
Previous occurrence
Look backward instead:
Pitfalls & errors
“On or after” vs “strictly after.” The main formula returns today if it already matches. Use the strictly-after variant when you must move to a future date.
Keep DOW on the default scale (Sunday = 1) to match WEEKDAY’s default, or set both consistently.
Format as a date. The result is a serial number — apply a Date format to the cell.
Practice workbook
Frequently asked questions
How do I find the next Monday (or any weekday) from a date in Excel?
How do I get the next weekday strictly after the date?
How do I find the next business day?
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