**How to calculate the next Monday from any date by formula with Excel?**

## Excel formula to calculate the Next Monday

To calculate the next Monday automatically according to the date of today, the formula is:

=TODAY()-WEEKDAY(TODAY()-2)+7

But, if you want to calculate the next Monday from another date in B1 for instance, the formula is:

=B1-WEEKDAY(B1-2)+7

## Other formulas for Monday

- Formula Next Monday
- Monday in two weeks
- Previous Monday
- Monday previous week
- Monday 2 weeks ago
- First Monday of the Month