Calculate Monday Previous Week with Excel

Calculate Monday Previous Week with Excel
Last Updated on 16/05/2023
Reading time: < 1 minute

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

Excel formula monday previous week from today

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

Excel formula monday previous week from any date

Other formulas for Monday

Leave a Reply

Your email address will not be published. Required fields are marked *

Calculate Monday Previous Week with Excel

Reading time: < 1 minute
Last Updated on 16/05/2023

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

Excel formula monday previous week from today

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

Excel formula monday previous week from any date

Other formulas for Monday

Leave a Reply

Your email address will not be published. Required fields are marked *