How to calculate the previous Monday from any date by formula with Excel?
Excel formula to calculate the Previous Monday
To calculate the previous Monday automatically according to the date of today, the formula is:
=TODAY()-WEEKDAY(TODAY()-1)+1
But, if you want to calculate the previous 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
