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