Weeks ago calculator
Count back whole weeks from today or any date. The answer is always the same weekday as the day you start from.
2 weeks ago was
Tuesday, September 15, 2026
That was exactly 14 days ago.
Quick answers
Counted back from today, Tuesday, September 29, 2026. Each one has its own page with conversions and a spreadsheet formula.
- 1 week ago: Tuesday, September 22, 2026
- 2 weeks ago: Tuesday, September 15, 2026
- 3 weeks ago: Tuesday, September 8, 2026
- 4 weeks ago: Tuesday, September 1, 2026
- 5 weeks ago: Tuesday, August 25, 2026
- 6 weeks ago: Tuesday, August 18, 2026
- 8 weeks ago: Tuesday, August 4, 2026
- 10 weeks ago: Tuesday, July 21, 2026
- 12 weeks ago: Tuesday, July 7, 2026
- 16 weeks ago: Tuesday, June 9, 2026
- 20 weeks ago: Tuesday, May 12, 2026
- 26 weeks ago: Tuesday, March 31, 2026
- 52 weeks ago: Tuesday, September 30, 2025
How it's calculated
N weeks ago is today's date minus 7 × N days, so it's always the same weekday as today.
In Excel or Google Sheets
- 2 weeks ago:
=TODAY()-2*7 - From a date in cell A1:
=A1-2*7
More date calculators
Frequently asked questions
Is it always the same weekday?
Yes. Counting back whole weeks keeps the weekday, so every answer from today is a Tuesday.
How many days is that?
Seven per week: 4 weeks ago is 28 days ago, 12 weeks ago is 84 days ago.
How do I do this in a spreadsheet?
Use =TODAY()-4*7 for four weeks ago, or =A1-4*7 with a date in cell A1.