How it's counted
Days since are counted from the date to today, not including the date itself.
In a spreadsheet
In Excel or Google Sheets, type =TODAY()-49 and format the cell as a date. To count from a different start date, use the date calculator.
7 weeks before other dates
| Starting from | 7 weeks earlier |
|---|---|
| Tue, Oct 13 (today) | Tuesday, August 25, 2026 |
| Mon, Oct 12 | Monday, August 24, 2026 |
| Sun, Oct 11 | Sunday, August 23, 2026 |
| Sat, Oct 10 | Saturday, August 22, 2026 |
| Fri, Oct 9 | Friday, August 21, 2026 |
| Thu, Oct 8 | Thursday, August 20, 2026 |
| Wed, Oct 7 | Wednesday, August 19, 2026 |
Weeks ago
Frequently asked questions
What day is 7 weeks ago?
7 weeks ago was Tuesday, August 25, 2026.
What day of the week is 7 weeks ago?
It was a Tuesday.
What was the date 7 weeks ago?
Tuesday, August 25, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 7 weeks?
49 calendar days is 7.0 weeks.
What date is 7 weeks from today?
Tuesday, December 1, 2026.
Does "7 weeks ago" include today?
No. Today is day 0, so the count starts from tomorrow (or yesterday, for dates in the past).
How do I work out 7 weeks ago in Excel or Google Sheets?
Type =TODAY()-49 and format the cell as a date.
How many business days are in 7 weeks?
From today it is 35 weekdays (Monday to Friday), before public holidays.