Home » Function » Date » Calculate Monday Previous Week with Excel

# Calculate Monday Previous Week with Excel

Last Updated on 16/05/2023 by Frédéric LE GUEN

How to calculate the Monday for the previous week from any date by formula with Excel?

## Excel formula to calculate Monday of the previous week

To calculate Monday of the previous week automatically according to the date of today, the formula is:

=TODAY()-WEEKDAY(TODAY()-1)+1-7

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

=B1-WEEKDAY(B1-1)+1-7

# Calculate Monday Previous Week with Excel

Last Updated on 16/05/2023 by Frédéric LE GUEN

How to calculate the Monday for the previous week from any date by formula with Excel?

## Excel formula to calculate Monday of the previous week

To calculate Monday of the previous week automatically according to the date of today, the formula is:

=TODAY()-WEEKDAY(TODAY()-1)+1-7

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

=B1-WEEKDAY(B1-1)+1-7