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