Overview & Concepts
A date of birth calculator finds the exact time that has passed between a starting date (the date of birth) and an end date, usually today. The tricky part isn't the concept — it's that months don't all have the same number of days, and every four years February gets an extra one. Doing this by hand means subtracting years, months, and days separately, then borrowing across columns whenever a subtraction would go negative, much like borrowing in ordinary column subtraction.
Our Calculator tool automates this borrowing process instantly, but understanding the method below is useful for checking results by hand, for school assignments, or for building the logic into a spreadsheet.
Step-by-Step Mathematical Method
Let the date of birth be Year1-Month1-Day1, and the target (end) date be Year2-Month2-Day2. Subtract each component separately, starting from days:
General Age Calculation Method
Copy this step-by-step process:
The only place this method requires care is Step 1: the number of days you add back depends on which month you're borrowing from (28, 29, 30, or 31 days), and whether that month is February in a leap year.
Days in Each Month (for Borrowing)
| Month | Days (Regular Year) | Days (Leap Year) |
|---|---|---|
| January | 31 | 31 |
| February | 28 | 29 |
| March | 31 | 31 |
| April | 30 | 30 |
| May | 31 | 31 |
| June | 30 | 30 |
| July | 31 | 31 |
| August | 31 | 31 |
| September | 30 | 30 |
| October | 31 | 31 |
| November | 30 | 30 |
| December | 31 | 31 |
Worked Examples with Solutions
Example 1: No borrowing needed. Find the age of someone born on March 15, 2000, as of August 25, 2026.
Example 1 Walkthrough
Copy each calculation step:
Example 2: Borrowing across both days and months. Find the age of someone born on July 20, 1995, as of February 10, 2026.
Example 2 Walkthrough
Copy each calculation step:
Common Mistakes & Tips
A few errors come up repeatedly when calculating age by hand:
- Forgetting leap years when borrowing in February: if the month you're borrowing days from is February, you must check whether that specific year is a leap year (29 days) or not (28 days) before adding it back.
- Mixing up which year to check for the leap day: when borrowing from February, always check the year February actually falls in — not the birth year or the end year by default.
- Counting the birthday itself incorrectly: if the day, month, and year all match exactly (e.g., calculating age exactly on a birthday), the result should come out to whole years with 0 months and 0 days — a good way to test your arithmetic.
- Off-by-one errors near month boundaries: always subtract Day1 from Day2 first and resolve any borrowing there before touching the month column, since a day borrow can change the month subtraction that follows.