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
Sunday, November 1, 2026
That was exactly 14 days ago.
Quick answers
Counted back from today, Sunday, November 15, 2026. Each one has its own page with conversions and a spreadsheet formula.
- 1 week ago: Sunday, November 8, 2026
- 2 weeks ago: Sunday, November 1, 2026
- 3 weeks ago: Sunday, October 25, 2026
- 4 weeks ago: Sunday, October 18, 2026
- 5 weeks ago: Sunday, October 11, 2026
- 6 weeks ago: Sunday, October 4, 2026
- 8 weeks ago: Sunday, September 20, 2026
- 10 weeks ago: Sunday, September 6, 2026
- 12 weeks ago: Sunday, August 23, 2026
- 16 weeks ago: Sunday, July 26, 2026
- 20 weeks ago: Sunday, June 28, 2026
- 26 weeks ago: Sunday, May 17, 2026
- 52 weeks ago: Sunday, November 16, 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 Sunday.
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.