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()-1 and format the cell as a date.
1 day before other dates
| Starting from | 1 day earlier |
|---|---|
| Mon, Oct 5 (today) | Sunday, October 4, 2026 |
| Sun, Oct 4 | Saturday, October 3, 2026 |
| Sat, Oct 3 | Friday, October 2, 2026 |
| Fri, Oct 2 | Thursday, October 1, 2026 |
| Thu, Oct 1 | Wednesday, September 30, 2026 |
| Wed, Sep 30 | Tuesday, September 29, 2026 |
| Tue, Sep 29 | Monday, September 28, 2026 |
Days ago
1 day agoSun, Oct 42 days agoSat, Oct 33 days agoFri, Oct 24 days agoThu, Oct 15 days agoWed, Sep 306 days agoTue, Sep 297 days agoMon, Sep 288 days agoSun, Sep 279 days agoSat, Sep 2610 days agoFri, Sep 2514 days agoMon, Sep 2115 days agoSun, Sep 2020 days agoTue, Sep 1521 days agoMon, Sep 1430 days agoSat, Sep 540 days agoWed, Aug 2645 days agoFri, Aug 2160 days agoThu, Aug 690 days agoTue, Jul 7100 days agoSat, Jun 27120 days agoSun, Jun 7180 days agoWed, Apr 8365 days agoSun, Oct 5, 2025
Frequently asked questions
What day is 1 day ago?
1 day ago was Sunday, October 4, 2026.
What day of the week is 1 day ago?
It was a Sunday.
What was the date 1 day ago?
Sunday, October 4, 2026. The date moves forward by one day every day, so this page always counts from today.
How many weeks is 1 day?
1 calendar day is 0.1 weeks.