Days Alive Calculator

Count the days, hours and seconds since you were born

Someone born on March 15, 1996 had lived 11,174 days by October 18, 2026. Counting the day of birth as day 1, October 18 is day 11,175. Enter a date of birth in the calculator above and it shows both numbers, then converts the same stretch of time into weeks, months, hours, minutes and seconds. When the date to count up to is today, the seconds keep ticking up live.

Beside the result you will find round-number milestones such as 10,000 days, 1 billion seconds, 1,000 weeks and 100 months, with the date each one falls on and how far along you are toward the next. The life-in-weeks map below fills in one cell for every week you have lived. For your age in years, months and days, use the age calculator; for your zodiac sign, try the zodiac calculator.

When it helps to count your days

• Planning a milestone: 10,000 days arrives at about age 27 and 1 billion seconds at about age 31. Knowing the date ahead of time gives you room to plan a dinner or a note to yourself. For a March 15, 1996 birth, 10,000 days is August 1, 2023 and 1 billion seconds is November 22, 2027.
• Dating a baby's first weeks: counting the birth date as day 1, day 100 for a baby born January 1, 2026 is April 10, 2026 (a Friday). If you count 100 days passed instead, you land on April 11. The switch above lets you pick either.
• Seeing elapsed time at a glance: a number like 11,174 is hard to feel. The life-in-weeks map lays 90 years out as one cell per week, so weeks lived and weeks ahead appear at the same size.
• Writing it down exactly: for a journal, a bio or a school assignment that asks "how many days old are you", you can copy a figure that already accounts for leap years.

How the calculation works

1. Days passed: the reference date minus the date of birth, as whole calendar days. The day of birth is 0 and the next day is 1. Dates are turned into day numbers before subtracting, so your device's time zone and daylight saving time do not change the result.
2. Day number: days passed plus 1. This counts the day of birth as day 1, the way people say "day 100" or "day 10,000".
3. Weeks: days passed divided by 7. The quotient is the number of weeks and the remainder is the extra days.
4. Months and age: a month is complete each time the same calendar date comes around. If a month has no matching date (the 31st in April, or February 29 in a common year), the calculator treats that month as complete on the day after the last day of that month. Age in years follows the same rule.
5. Hours, minutes, seconds: the real time elapsed from the moment of birth to the reference moment. For today, that is up to this instant; for any other date, up to 12:00 AM at the start of that date. If you leave the time of birth empty, birth is taken as 12:00 AM that day.
6. Milestones: a day milestone is the birth date plus that many days (one day earlier if you turn on day-1 counting), a week milestone is the birth date plus 7 times that many days, and month milestones follow the month rule above. Hour, minute and second milestones add that length of time to the moment of birth.
7. Moon and Earth: lunar cycles are the days elapsed divided by the 29.53-day synodic month. The orbit distance is the seconds elapsed times Earth's mean orbital speed of 29.78 km per second (NASA data). Both are estimates.

Example: born March 15, 1996, counted to October 18, 2026

The next milestone for this person is 1 billion seconds, at 1:46:40 AM on November 22, 2027, followed by 12,000 days on January 21, 2029 (a Sunday). If the birth was at 7:30 AM instead of midnight, the second count drops by 27,000 to 965,406,600, and the hour count, which counts complete hours only, shows 268,168.

When round-number milestones arrive

This table converts each milestone into days and shows when it lands for someone born at 12:00 AM on March 15, 1996 in the America/New_York time zone, together with their age on that date.

Days lived by age

Two people with the same birthday can differ by a day, depending on how many February 29s fall between birth and the birthday. The table covers anyone born from March 1, 1901 through February 28, 2000 and shows the days passed on the birthday when they reach each age.

At ages that are multiples of 20 the number of leap days is always the same, so the total is a single value. The year 2100 is not a leap year, so any period that crosses the end of February 2100 has one day fewer than this table shows.

Doing it in Excel or Google Sheets

Assume the date of birth is in cell A2 as a real date. Format the result cell as a number, or Excel will show a date instead of a count.

• Days passed: =TODAY()-A2 or =DATEDIF(A2,TODAY(),"D")
• Day number: =TODAY()-A2+1
• Completed months: =DATEDIF(A2,TODAY(),"M")
• The 10,000-day date: =A2+10000 (format as a date)
• Seconds so far, if born at midnight: =(NOW()-A2)*86400

According to Microsoft, DATEDIF exists to support older Lotus 1-2-3 workbooks, and its "MD" argument can return an inaccurate result, a zero or a negative number. For the days left over after full months, the month row of this calculator is the safer check.

Reading the life-in-weeks map

Each vertical column is one year of age, from one birthday to the day before the next, and the 52 cells running down are that year's weeks. A year is 52 weeks plus one or two days, so the last cell of each column holds 8 or 9 days. Ninety years comes to 4,680 cells, and past age 90 the map grows in 10-year steps.

For someone born on March 15, 1996, October 18, 2026 sits in the age-30 column at week 32, with 1,591 cells filled before it. The 10,000-day mark is in the age-27 column at week 20. Circles mark big milestones such as 10,000 days and 1 billion seconds. Drawing a life as a grid of weeks follows the approach of "Your Life in Weeks" on Wait But Why (2014).

Common mistakes

• Multiplying age by 365: this skips the leap days. By a 30th birthday you are short by 7 or 8 days, since 30 × 365 = 10,950 while the real count is 10,957 or 10,958.
• Mixing day 0 and day 1: the big number here is days passed. If you want the birth date counted as day 1, turn on the switch. The two always differ by exactly one.
• Entering a date from another calendar: the date fields use the Gregorian calendar. Convert a lunar or religious calendar date first.
• Treating a February 29 birthday as February 28: in common years this calculator counts the new year of age from March 1. You can still celebrate on February 28; that is a personal choice, not part of the count.
• Ignoring time zones: the day count is the same everywhere, but hours and seconds shift by the gap between where you were born and this device's time zone. Convert the birth time to this device's local time for an exact figure.

Limits of this calculator

• Dates must fall between January 1, 1900 and December 31, 2100.
• Hours and seconds use your device's time zone and its daylight saving rules. You cannot choose a different time zone for the birthplace.
• Leap seconds are not counted. According to the IERS, 27 leap seconds were added from 1972 through the end of 2016, and none will be added at the end of 2026. If you were born before 2017, the real number of elapsed seconds is higher than shown by the leap seconds added since your birth (27 if born before 1972).
• Lunar cycles and orbit distance use averages, so they are estimates. The number of full moons you have actually seen can differ by about one.
• The date of birth and time you enter are not stored in the address or on the device. Use Copy result to keep a record.

Basis Dates use the Gregorian calendar. The examples and tables in this article were calculated on October 18, 2026, and the milestone table uses the America/New_York time zone.

Sources

• 01IERS: Bulletin C 72July 6, 2026; no leap second at the end of 2026, UTC−TAI = −37 s
• 02IERS: Leap_Second.datJan 1, 1972: 10 s, to Jan 1, 2017: 37 s
• 03NASA: Moon Fact SheetSynodic month 29.53 days
• 04NASA: Earth Fact SheetMean orbital velocity 29.78 km/s
• 05Microsoft Support: DATEDIF function
• 06Wait But Why: Your Life in Weeks2014

Frequently asked questions

Related tools