Calculate Monday in 2 weeks with Excel

Reading time: < 1 minutes
Last Updated on 16/05/2023 by Frédéric LE GUEN

How to calculate Monday in two weeks by formula with Excel?

Excel formula to calculate Monday in 2 weeks

To calculate Monday in 2 weeks automatically according to the date of today, the formula is:

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

Formula monday in two weeks from today

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

=B1-WEEKDAY(B1-2)+7

Formula monday in two weeks from any date

Formulas to calculate Monday for any next weeks

Now, if you want to calculate the next Monday in 3 weeks, 4 weeks, you just have to change the last value in the formula

Formula for Monday for the next weeks

Other formulas for Monday

Leave a Reply

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

Calculate Monday in 2 weeks with Excel

Reading time: < 1 minutes
Last Updated on 16/05/2023 by Frédéric LE GUEN

How to calculate Monday in two weeks by formula with Excel?

Excel formula to calculate Monday in 2 weeks

To calculate Monday in 2 weeks automatically according to the date of today, the formula is:

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

Formula monday in two weeks from today

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

=B1-WEEKDAY(B1-2)+7

Formula monday in two weeks from any date

Formulas to calculate Monday for any next weeks

Now, if you want to calculate the next Monday in 3 weeks, 4 weeks, you just have to change the last value in the formula

Formula for Monday for the next weeks

Other formulas for Monday

Leave a Reply

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