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()-98 and format the cell as a date. To count from a different start date, use the date calculator.
14 weeks before other dates
| Starting from | 14 weeks earlier |
|---|---|
| Tue, Oct 13 (today) | Tuesday, July 7, 2026 |
| Mon, Oct 12 | Monday, July 6, 2026 |
| Sun, Oct 11 | Sunday, July 5, 2026 |
| Sat, Oct 10 | Saturday, July 4, 2026 |
| Fri, Oct 9 | Friday, July 3, 2026 |
| Thu, Oct 8 | Thursday, July 2, 2026 |
| Wed, Oct 7 | Wednesday, July 1, 2026 |
Weeks ago
Frequently asked questions
What day is 14 weeks ago?
14 weeks ago was Tuesday, July 7, 2026.
What day of the week is 14 weeks ago?
It was a Tuesday.
What was the date 14 weeks ago?
Tuesday, July 7, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 14 weeks?
98 calendar days is 14.0 weeks.
What date is 14 weeks from today?
Tuesday, January 19, 2027.
Does "14 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 14 weeks ago in Excel or Google Sheets?
Type =TODAY()-98 and format the cell as a date.
How many business days are in 14 weeks?
From today it is 70 weekdays (Monday to Friday), before public holidays.