Find the Next Monday (or Any Weekday) in Excel

To find the next Monday date in Excel, add 8 to the date and subtract its weekday number: =A2+8-WEEKDAY(A2,2). The same idea, with MOD, finds the next Friday or any other day of the week. This guide is for anyone scheduling shipments, reviews, payroll or meetings that always fall on a set weekday, and it covers the previous Monday and the first Monday of a month too.

How to find the next Monday after a date#

Use WEEKDAY with return type 2, which numbers the days from Monday = 1 to Sunday = 7. If the date is in A2, type:

=A2+8-WEEKDAY(A2,2)

This works because Excel stores dates as whole numbers, one per day, so adding 5 to a date moves it 5 days forward. From any day, 8 minus its weekday number is exactly the number of days left until the next Monday. A Monday gets 7 days added, so the result is always after the start date, never the same day.

If you see a number like 46335 instead of a date, the formula is fine: the cell just needs a date format (Home > Number Format > Short Date). The guide to adding days, months and years explains how date arithmetic works.

Next Monday, or the same day if it is already Monday#

Sometimes a Monday should stay where it is, for example when a task can start the same day. Use MOD to add 0 days for a Monday:

=A2+MOD(1-WEEKDAY(A2,2),7)

For Mon 2 Nov 2026, 1-1 is 0, so the result is the same date. For Wed 4 Nov 2026, 1-3 is −2, and MOD(−2,7) is 5, so the result is Mon 9 Nov 2026. MOD keeps the answer between 0 and 6, which is why negative numbers turn into the right count of days.

How to find the next Friday or any weekday#

Swap the day number into a general formula. With return type 2, Monday is 1, Tuesday 2, Wednesday 3, Thursday 4, Friday 5, Saturday 6 and Sunday 7. For the next day d strictly after A2:

=A2+MOD(d-1-WEEKDAY(A2,2),7)+1

For the next Friday (d = 5):

=A2+MOD(4-WEEKDAY(A2,2),7)+1

From Wed 4 Nov 2026, this returns Fri 6 Nov 2026. From Fri 6 Nov it returns Fri 13 Nov, the following week. For a version you can change without editing the formula, put the day number in a cell, such as E1, and use =A2+MOD(E1-1-WEEKDAY(A2,2),7)+1. The lesson on EDATE, EOMONTH and WEEKDAY lets you practise WEEKDAY's return types.

How to find the next weekday with WORKDAY.INTL#

WORKDAY.INTL (Excel 2010 and later) can treat every day except Monday as a weekend, so "the next working day" becomes "the next Monday":

=WORKDAY.INTL(A2,1,"0111111")

The seven-character text describes Monday to Sunday: 0 is a working day and 1 is a weekend day. Here only Monday is a working day, so the formula returns the next Monday after A2: Mon 9 Nov 2026 from Wed 4 Nov. For the next Friday, use "1111011".

A bonus of this method is the optional holidays argument. =WORKDAY.INTL(A2,1,"0111111",H2:H5) skips a Monday that appears in the holiday list in H2:H5 and returns the Monday after. For ordinary working days (Monday to Friday), the simpler WORKDAY does the job: =WORKDAY(A2,1) gives the next working day. The WORKDAY function guide covers it, and the due date formulas guide shows both in deadlines.

How to find the previous Monday (start of the week)#

To go back to the Monday of the same week, use return type 3, which numbers Monday as 0 and Sunday as 6:

=A2-WEEKDAY(A2,3)

For Wed 4 Nov 2026, WEEKDAY returns 2, so the result is Mon 2 Nov 2026. A Monday returns itself. This is the formula for "week starting" columns in weekly reports and timesheets.

Next Monday from today, and the first Monday of a month#

To find next Monday from today's date, replace A2 with TODAY():

=TODAY()+8-WEEKDAY(TODAY(),2)

The result changes every day. If you need to keep the date, copy the cell and paste it as a value.

For the first Monday of a month, start from the 1st and use the "on or after" version:

=DATE(2026,12,1)+MOD(1-WEEKDAY(DATE(2026,12,1),2),7)

December 1, 2026 is a Tuesday, so the result is Mon 7 Dec 2026. To count down to dates like these, see days until a deadline.

Common mistakes with next weekday formulas#

These slips cause most wrong dates:

1. Leaving out the return type. WEEKDAY(A2) uses Sunday = 1 to Saturday = 7, so =A2+8-WEEKDAY(A2) finds the next Sunday, not Monday. Always write the 2.
2. Dates stored as text. A date typed as text, such as one imported from another system, gives #VALUE!. Convert it with DATEVALUE or Text to Columns first.
3. Strictly after vs on or after. Decide whether a Monday should stay the same or move a week, then pick the matching formula.
4. A number instead of a date. Format the result cell as a date.
5. Checking the result by eye. Add a day name next to it with =TEXT(B2,"dddd") to confirm it really is a Monday; see how to get the day name from a date.

Practise it#

Try the exercise on this page: it finds a shipping Monday with WEEKDAY. Then practise WEEKDAY, EDATE and EOMONTH in a live spreadsheet, and practise NETWORKDAYS and WORKDAY to skip weekends and holidays in real deadlines.