Calculate Monday 2 weeks ago with Excel

Calculate Monday 2 weeks ago with Excel
Last Updated on 09/07/2023
Reading time: < 1 minute

How to calculate Monday 2 weeks ago from any date by formula with Excel?

Excel formula to calculate Monday 2 weeks ago

To calculate Monday 2 weeks ago automatically according to the date of today, the formula is:

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

Excel formula to calculate monday 2 weeks ago

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

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

Excel formula to calculate monday 2 weeks ago from any date

Formulas to calculate Monday for any previous weeks

Now, if you want to calculate Monday 3 or 4 weeks ago, you just have to change the last value in the formula

Excel Formula for Monday for any previous week

Other formulas for Monday

Leave a Reply

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

Calculate Monday 2 weeks ago with Excel

Reading time: < 1 minute
Last Updated on 09/07/2023

How to calculate Monday 2 weeks ago from any date by formula with Excel?

Excel formula to calculate Monday 2 weeks ago

To calculate Monday 2 weeks ago automatically according to the date of today, the formula is:

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

Excel formula to calculate monday 2 weeks ago

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

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

Excel formula to calculate monday 2 weeks ago from any date

Formulas to calculate Monday for any previous weeks

Now, if you want to calculate Monday 3 or 4 weeks ago, you just have to change the last value in the formula

Excel Formula for Monday for any previous week

Other formulas for Monday

Leave a Reply

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