How to calculate Monday 2 weeks ago from any date by formula with Excel?
Excel formula to calculate Monday 2 weeks ago
To calculate Monday 2 weeks ago automatically according to the date of today, the formula is:
=TODAY()-WEEKDAY(TODAY()-1)+1-7*2

But, if you want to calculate the Monday 2 weeks ago from another date in B1 for instance, the formula is:
=B1-WEEKDAY(B1-1)+1-7*2

Formulas to calculate Monday for any previous weeks
Now, if you want to calculate Monday 3 or 4 weeks ago, you just have to change the last value in the formula

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