# Calculate the Previous Monday with Excel

Last Updated on 01/06/2024

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.

# Calculate the Previous Monday with Excel

Last Updated on 01/06/2024

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.