Return the next monday

You can return the next Monday using
Cell "A1" displays a date
Cell "A2" displays the next Monday
Cell "A3" displays an alternative formula
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A
1=TODAY() = 02 Monday December 2019
2=A1+MOD(8 -WEEKDAY(A1,2),7) = 02 Monday December 2019
3=A1+IF(2<WEEKDAY(A1),7-WEEKDAY(A1)+2,2 -WEEKDAY(A1)) = 02 Monday December 2019

Built-in Functions

IF - The value based on a logical test that is either True or False.
MOD - The remainder after division.
TODAY - The 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


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