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()-280 and format the cell as a date. To count from a different start date, use the date calculator.
40 weeks before other dates
| Starting from | 40 weeks earlier |
|---|---|
| Tue, Oct 13 (today) | Tuesday, January 6, 2026 |
| Mon, Oct 12 | Monday, January 5, 2026 |
| Sun, Oct 11 | Sunday, January 4, 2026 |
| Sat, Oct 10 | Saturday, January 3, 2026 |
| Fri, Oct 9 | Friday, January 2, 2026 |
| Thu, Oct 8 | Thursday, January 1, 2026 |
| Wed, Oct 7 | Wednesday, December 31, 2025 |
Weeks ago
1 week agoTue, Oct 62 weeks agoTue, Sep 293 weeks agoTue, Sep 224 weeks agoTue, Sep 155 weeks agoTue, Sep 86 weeks agoTue, Sep 17 weeks agoTue, Aug 258 weeks agoTue, Aug 189 weeks agoTue, Aug 1110 weeks agoTue, Aug 411 weeks agoTue, Jul 2812 weeks agoTue, Jul 2113 weeks agoTue, Jul 1414 weeks agoTue, Jul 715 weeks agoTue, Jun 3016 weeks agoTue, Jun 2320 weeks agoTue, May 2624 weeks agoTue, Apr 2826 weeks agoTue, Apr 1430 weeks agoTue, Mar 1740 weeks agoTue, Jan 652 weeks agoTue, Oct 14, 2025
Frequently asked questions
What day is 40 weeks ago?
40 weeks ago was Tuesday, January 6, 2026.
What day of the week is 40 weeks ago?
It was a Tuesday.
What was the date 40 weeks ago?
Tuesday, January 6, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 40 weeks?
280 calendar days is 40.0 weeks.
What date is 40 weeks from today?
Tuesday, July 20, 2027.
Does "40 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 40 weeks ago in Excel or Google Sheets?
Type =TODAY()-280 and format the cell as a date.
How many business days are in 40 weeks?
From today it is 200 weekdays (Monday to Friday), before public holidays.