Return the next Monday

You can return the next Monday using


 A
1=TODAY() = 19 Sunday May 2024
2=A1 + MOD(8 - WEEKDAY(A1, 2), 7) = 20 Monday May 2024
3=A1+IF(2<WEEKDAY(A1), 7-WEEKDAY(A1)+2, 2 - WEEKDAY(A1) ) = 20 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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top