Days since common dates
Counted up to today, October 19, 2026:
| Since | Days | Years, months, days |
|---|---|---|
| January 1, 2026 | 291 | 9 months 18 days |
| January 1, 2000 | 9788 | 26 years 9 months 18 days |
| January 1, 2020 | 2483 | 6 years 9 months 18 days |
| Last Christmas | 298 | 9 months 24 days |
| Last New Year’s Day | 291 | 9 months 18 days |
| The Moon landing (July 20, 1969) | 20910 | 57 years 2 months 29 days |
Two ways to count “days since”
| Method | Start day | Yesterday to today | Used for |
|---|---|---|---|
| Standard (elapsed days) | Not counted | 1 day | Ages, durations, spreadsheets |
| Day 1 counting | Counted as day 1 | 2 days | Streaks, sobriety and habit counters, “day 30 of the challenge” |
The two always differ by exactly one day. Pick the one that matches how you count, using the Start Day option above.
\text{days since} = \text{today} - \text{start date}Day-count milestones
People mark round numbers of days as well as yearly anniversaries:
- 100 days – about 3 months and 1 week; a common relationship and new-job milestone.
- 1000 days – about 2 years and 9 months.
- 10000 days – about 27 years and 4 months; many people celebrate their 10000th day alive.
- 20000 days – about 54 years and 9 months.
The Milestones table in the result gives the exact dates for your start date.
Days since a date in Excel or Google Sheets
| You want | Formula (start date in A2) |
|---|---|
| Days since | =TODAY()-A2 |
| Counting the start day as day 1 | =TODAY()-A2+1 |
| Years, months and days | =DATEDIF(A2,TODAY(),"Y"), "YM", "MD" |
Frequently asked questions
How many days has it been since January 1?
As of today, October 19, 2026, 291 days have passed since January 1, 2026.
Is the start date counted?
Not by default: from yesterday to today is 1 day. Choose “Counted as day 1” if you count streaks, where the first day is day 1.
When is my 10000th day?
Enter your date of birth as the start date. The Milestones table shows the date you reach 10000 days, about 27 years and 4 months after birth.
How do I count only working days since a date?
The result shows weekdays (Monday to Friday). To leave out public holidays as well, use the Business Days Calculator.
What is the difference from the Age Calculator?
Both count the time from a past date. The Age Calculator focuses on years, months and days and the next birthday; this page focuses on the day count and milestones.