How to Calculate Age from Date of Birth — Exact Years, Months, Days
Learn how to calculate exact age from date of birth in years, months, and days — with manual method, formula, and practical uses for forms and documents.
Calculating your age in complete years is simple — subtract your birth year from the current year. But when a form asks for your exact age in years, months, and days, or when you need to verify age eligibility for a government scheme, the calculation gets trickier.
Here's how to calculate exact age manually, and when to use the CalcHub age calculator for instant, accurate results.
The Manual Method
To calculate exact age in years, months, and days:
- Write down the current date and birth date
- Subtract days first (borrow from months if needed)
- Subtract months (borrow from years if needed)
- Subtract years
Worked Example:
Date of Birth: July 18, 1995 Current Date: March 28, 2026Step 1: Days
28 - 18 = 10 days
Step 2: Months
March (3) - July (7) = negative, so borrow 1 year
(3 + 12) - 7 = 15 - 7 = 8 months
Step 3: Years
2026 - 1995 - 1 (borrowed) = 30 years
Age: 30 years, 8 months, 10 days
Trickier Example (with borrowing for days):
Date of Birth: October 25, 1990 Current Date: March 10, 2026Step 1: Days
10 - 25 = negative, so borrow 1 month
February has 28 days in 2026, so: (10 + 28) - 25 = 13 days
Step 2: Months
(3 - 1 borrowed) - 10 = 2 - 10 = negative, borrow 1 year
(2 + 12) - 10 = 4 months
Step 3: Years
2026 - 1990 - 1 (borrowed) = 35 years
Age: 35 years, 4 months, 13 days
Why Exact Age Matters
Several real-world scenarios require exact age calculation:
| Scenario | Why Exact Age Matters |
|---|---|
| Government job applications | Age limits are strict — even one day matters |
| Insurance policies | Premium rates change at exact age boundaries |
| Passport application | Minor vs adult classification |
| School admission | Date cutoffs for academic year eligibility |
| Retirement | Superannuation date is exact birth date + retirement age |
| Legal age (voting, driving, marriage) | Must have completed the required years |
| Senior citizen benefits | Tax benefits kick in at exactly 60 years |
Age Calculation on Specific Dates
Sometimes you need your age on a specific past or future date, not today. The method is the same — just replace "current date" with the target date.
Example: Age on exam date
Date of Birth: May 15, 2000 Exam Date: August 1, 2026Days: 1 - 15 = negative → (1 + 31) - 15 = 17 days (July has 31 days)
Months: (8 - 1) - 5 = 2 months
Years: 2026 - 2000 = 26 years
Age on exam date: 26 years, 2 months, 17 days
Leap Year Considerations
If you're born on February 29:
- In non-leap years, your birthday is typically considered March 1 for legal purposes (in most jurisdictions)
- Age calculators should handle this correctly — the CalcHub age calculator accounts for leap years automatically
- For form submissions, use your actual date of birth (Feb 29) and let the system handle the logic
Additional Age Formats
Sometimes you need age in non-standard formats:
Age in months = (years × 12) + months
Age in weeks = total days / 7
Age in days = count all days from birth to target date
For the first example (DOB: July 18, 1995, to March 28, 2026):
- Age in months: (30 × 12) + 8 = 368 months
- Age in days: 11,211 days (approximate — exact count requires accounting for leap years)
Practical Tips
1. For government forms, read the age cutoff carefully. "Age should not exceed 35 years as on 01-01-2026" means you must be 35 or younger on that specific date, not on the application date. 2. Indian government jobs use "as on" date. SSC, UPSC, and other exams specify an "as on" date for age calculation. Calculate your age on that exact date, not today. 3. For insurance, age at next birthday is common. Some insurers use "age nearest birthday" — if you're 35 years and 7 months, you're rated as 36. This affects premiums.How do different countries count age?
Most countries use the Western system — you turn 1 on your first birthday. In Korean age (traditionally), you're 1 at birth and gain a year every January 1. South Korea officially adopted the international age counting system in 2023.
Is there a formula for age in Excel?
Yes: =DATEDIF(birth_date, today(), "Y") & " years, " & DATEDIF(birth_date, today(), "YM") & " months, " & DATEDIF(birth_date, today(), "MD") & " days". Or simply use the CalcHub age calculator — no formula needed.
My age calculator shows a different result than manual calculation. Which is right?
The most common error in manual calculation is incorrect borrowing — especially when the birth day is greater than the current day. Digital calculators handle this automatically and are typically more reliable for edge cases (month boundaries, leap years).
Related Calculators
- Age Calculator — instant exact age from any date of birth
- Date Difference Calculator — days between any two dates
- Retirement Age Calculator — when will you reach retirement age
- Birthday Calculator — day of the week you were born, next birthday countdown