Calculate the Next Monday with Excel

Calculate the Next Monday with Excel
Last Updated on 09/07/2023
Reading time: < 1 minute

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

Formula next monday from today

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

=B1-WEEKDAY(B1-2)+7

Excel Formula to calculate the next monday from any date

Other formulas for Monday

Leave a Reply

Your email address will not be published. Required fields are marked *

Calculate the Next Monday with Excel

Reading time: < 1 minute
Last Updated on 09/07/2023

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

Formula next monday from today

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

=B1-WEEKDAY(B1-2)+7

Excel Formula to calculate the next monday from any date

Other formulas for Monday

Leave a Reply

Your email address will not be published. Required fields are marked *