Calculate Monday 2 weeks ago with Excel

Most Viewed Posts

  1. Displaying Negative Numbers in Parentheses – Excel (261,089)
  2. How to make automatic calendar in Excel (161,501)
  3. Dash for 0 in Excel (133,263)
  4. Convert YYYYMMDD to DD/MM/YYYY (117,373)
  5. Date Format in Excel (113,299)
  6. Excel Split Date and Time (91,454)
  7. How to calculate VAT in Excel? (89,040)
  8. Exchange rate in Excel (81,120)
  9. UNIQUE Function – Remove duplicates with formulas (67,892)
  10. Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde (63,893)
  11. Add Emojis to your charts, formulas (60,179)
  12. Comma or Semicolon in an Excel formula (59,686)
  13. Compare 2 Columns (56,952)
  14. Change the default Date format in Excel (51,872)
  15. Dynamic SUM in Excel (44,965)
Home » Function » Date » Calculate Monday 2 weeks ago with Excel

Calculate Monday 2 weeks ago with Excel

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

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

Date
calculate monday,formula monday,monday

Leave a Reply

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

Excel Quiz

Recent Posts

Categories

Calculate Monday 2 weeks ago with Excel

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

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

Date
calculate monday,formula monday,monday

Leave a Reply

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