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

Check out these additional articles that explore different methods for calculating Mondays within a week or month.

• Formula Next Monday
• Monday in two weeks
• Monday previous week
• Monday 2 weeks ago
• First Monday of the Month
• Calculate a date from the week number in Excel
• How to Calculate the Week Number in Excel?
• Date Picker in Excel