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

Calculate the Previous Monday with Excel

Reading time: < 1 minutes
Last Updated on 16/05/2023 by Frédéric LE GUEN

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

Formula to calculate the previous monday from today

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

=B1-WEEKDAY(B1-2)+7

Formula to calculate the previous monday from any date

Other formulas for Monday

Leave a Reply

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

Calculate the Previous Monday with Excel

Reading time: < 1 minutes
Last Updated on 16/05/2023 by Frédéric LE GUEN

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

Formula to calculate the previous monday from today

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

=B1-WEEKDAY(B1-2)+7

Formula to calculate the previous monday from any date

Other formulas for Monday

Leave a Reply

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