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".
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.
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top