Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to find the next Monday after a date
Excel & Google Sheets
=TEXT(DATE(A2,B2,C2)+8-WEEKDAY(DATE(A2,B2,C2),2),"yyyy-mm-dd")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Year | Month | Day |
| 2026 | 9 | 14 |
=TEXT(DATE(A2,B2,C2)+8-WEEKDAY(DATE(A2,B2,C2),2),"yyyy-mm-dd")→2026-09-21
Both expressions are checked against an independently calculated expected result in HyperFormula. This is a sample execution check, not native Excel or Google Sheets certification.
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter numeric year, month and day in A2:C2.
- 2DATE creates the input date; WEEKDAY with return type 2 counts Monday as 1.
- 3Add 8 minus the weekday number. A Monday advances seven days and a Sunday advances one day.
- 4TEXT displays an unambiguous yyyy-mm-dd result. Remove the outer TEXT call and apply Date formatting if you need a numeric date for later calculations.
Tips
- This means strictly after the input date. For Monday on or after a date, use date + MOD(1-WEEKDAY(date,2),7).
- This is a calendar-weekday calculation and does not skip holidays. Validate the year/month/day inputs before passing them to DATE.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What happens on a Monday?
It returns the following Monday, seven days later.
Does this find the next business day?
No. It always targets Monday, even when that Monday is a holiday.
Sources and compatibility
Reviewed 2026-09-16