How to Calculate Age Manually — Step by Step

Updated August 2026 · AgeCalculator.bio Editorial

Working out someone's age sounds trivial — until you try to do it precisely. Months have different lengths, leap years add a day every four years (usually), and the answer changes depending on whether the birthday has already passed this year. This guide explains the standard method for calculating age from a date of birth, the same logic used by our free age calculator.

The Quick Method: Age in Years

To find someone's age in completed years:

1. Subtract the birth year from the current year.
2. If this year's birthday has not yet happened, subtract 1.

The Full Method: Years, Months and Days

Official forms often ask for age in years, months and days. The standard borrow-and-carry method works like subtraction:

1. Write both dates as day / month / year.
2. Subtract the days. If the result is negative, borrow one month: add the number of days in the month before the current one, and reduce the month difference by 1.
3. Subtract the months. If negative, borrow one year: add 12 to the months and reduce the year difference by 1.
4. Subtract the years.

Why Answers Can Differ Slightly

Because months are 28–31 days long, there are two reasonable conventions for the "months and days" remainder: borrowing the length of the previous month (used above and by most official bodies) or counting forward from the birth date. The two can differ by a day or two in edge cases — for instance, a birth on 31 January measured on 1 March. Whichever tool or method you use, the age in completed years is always the same.

Leap Years

A year is a leap year if it is divisible by 4, except century years, which must be divisible by 400. So 2024 and 2000 are leap years, but 1900 and 2100 are not. Because the method above works with actual calendar dates, leap days are handled automatically. Birthdays on 29 February are a special case — see our full guide to leap year birthdays.

Calculating Age in Days, Weeks, Hours

To convert an age into total days, count the days between the two dates (multiply full years by 365, add one day for each leap day in between, then add the remaining days — or let a tool do it). From total days you can derive:

• Weeks: total days ÷ 7
• Hours: total days × 24
• Minutes: total days × 1,440
• Seconds: total days × 86,400

A 25-year-old has lived roughly 9,130 days, 219,000 hours, or about 789 million seconds.

Common Mistakes to Avoid

• Forgetting the birthday check. Simply subtracting years overstates age for anyone whose birthday hasn't yet passed.
• Assuming every month has 30 days. Financial "30/360" conventions exist, but they are not used for legal age.
• Ignoring time zones. A person born late at night may have a different birth date in another time zone; legal age follows the place of birth's local date.
• Miscounting century leap years. 2000 was a leap year; 1900 and 2100 are not.

Calculating Age in Excel and Google Sheets

For a whole list of birth dates, spreadsheets are the manual method's best friend. Both Excel and Google Sheets support DATEDIF, a function designed exactly for this. With a date of birth in cell A2:

Note that DATEDIF's "MD" unit has documented quirks for some end-of-month dates — the same edge cases that make manual calculation tricky. For a single date, our age calculator is faster and avoids these pitfalls.

Age for Official Forms

Government and institutional forms usually want "age as on" a specific cut-off date — an exam eligibility date, an admission deadline, a census day. The method is identical: use the cut-off date instead of today as the target. Two tips from real-world form filling: first, always use the date format the form requests (DD/MM/YYYY vs MM/DD/YYYY confusion is the most common error); second, if a rule says "must not be over 25 years on 1 January", check whether the wording means completed years — being 25 years and 11 months usually still counts as 25.

Let the Calculator Do It

Manual calculation is a great skill, but for instant, error-free results — including total months, weeks, days, hours and a next-birthday countdown — use our free age calculator, date calculator, or age difference calculator. And if you're curious about milestone counts like your 10,000th day alive, see how many days old am I?