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()-105 and format the cell as a date. To count from a different start date, use the date calculator.
15 weeks before other dates
| Starting from | 15 weeks earlier |
|---|---|
| Tue, Oct 13 (today) | Tuesday, June 30, 2026 |
| Mon, Oct 12 | Monday, June 29, 2026 |
| Sun, Oct 11 | Sunday, June 28, 2026 |
| Sat, Oct 10 | Saturday, June 27, 2026 |
| Fri, Oct 9 | Friday, June 26, 2026 |
| Thu, Oct 8 | Thursday, June 25, 2026 |
| Wed, Oct 7 | Wednesday, June 24, 2026 |
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 15 weeks ago?
15 weeks ago was Tuesday, June 30, 2026.
What day of the week is 15 weeks ago?
It was a Tuesday.
What was the date 15 weeks ago?
Tuesday, June 30, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 15 weeks?
105 calendar days is 15.0 weeks.
What date is 15 weeks from today?
Tuesday, January 26, 2027.
Does "15 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 15 weeks ago in Excel or Google Sheets?
Type =TODAY()-105 and format the cell as a date.
How many business days are in 15 weeks?
From today it is 75 weekdays (Monday to Friday), before public holidays.