In this case, we only want to take action if the date in question is Monday.

If the expression returns FALSE, we simply return the original date.

By default, WEEKDAY returns 1 for Sunday and 7 for Saturday, but this is configurable.

Excel formula: Get next day of week

you’re free to use the WEEKDAY function inside other formulas to check the day of week.

More than one condition can be tested by nesting IF functions.

Excel formula: Add business days to date

Excel formula: Next business day 6 months in future

Excel formula: Get workdays between dates

Excel formula: Date is workday

Excel formula: Get Monday of the week

Excel WEEKDAY function

Excel IF function