Return the next Monday

You can return the next Monday using

	A
1	=TODAY() = 01 Wednesday May 2024
2	=A1 + MOD(8 - WEEKDAY(A1, 2), 7) = 06 Monday May 2024
3	=A1+IF(2<WEEKDAY(A1), 7-WEEKDAY(A1)+2, 2 - WEEKDAY(A1) ) = 06 Monday May 2024

1 - Displays a date
2 - Displays the next Monday
3 - Displays an alternative formula
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

Built-in Functions

IF - The value based on whether a condition is True or False.
MOD - The remainder after division.
TODAY - The date serial number representing today's date.
WEEKDAY - The day of the week for a given date.

Related Formulas

Return the previous Monday
Return the next Friday
Return the previous Friday