Chronological Age Guide
How to Calculate Chronological Age
To calculate chronological age, subtract the birth date from the reference date and express the result in years, months, and days. This guide covers the manual step-by-step method, the borrowing technique, how to convert to total months, and how to use Excel — plus a free online calculator for instant results.
The Chronological Age Formula
Chronological Age = Reference Date − Birth Date
Result expressed as Years ; Months ; Days
The reference date is usually today, but in standardized testing it is the exact date the assessment was administered. Using the wrong reference date is one of the most common scoring errors.
Step-by-Step Manual Method
Write down both dates
Record the full birth date (month, day, year) and the reference date — the day you are measuring age against.
Subtract the years
Subtract the birth year from the reference year to get a preliminary year count.
Subtract the months — borrow if needed
Subtract the birth month from the reference month. If the result is negative, borrow 12 from the year count and add 12 to the reference month before subtracting.
Subtract the days — borrow if needed
Subtract the birth day from the reference day. If the result is negative, borrow 1 from the month count and add the number of days in the previous month to the reference day.
Verify and format the result
Write the final age as Years; Months; Days (e.g., 6;8;24). Confirm months are 0–11 and days are 0–30.
Worked Example: Calculating with Borrowing
Borrowing is required when the reference day is smaller than the birth day, or the reference month is smaller than the birth month. Here is a complete example:
| Step | Year | Month | Day |
|---|---|---|---|
| Reference date (June 8, 2026) | 2026 | 6 | 8 |
| Birth date (Sept 15, 2019) | 2019 | 9 | 15 |
| Day borrow (8 < 15 → borrow May: 31 days) | 2026 | 6 − 1 = 5 | 8 + 31 = 39 |
| Month borrow (5 < 9 → borrow 1 year) | 2026 − 1 = 2025 | 5 + 12 = 17 | 39 |
| Result | 2025 − 2019 = 6 | 17 − 9 = 8 | 39 − 15 = 24 |
When borrowing the previous month's days, use the actual number of days in that month — 31 for May, 30 for April, 28 or 29 for February, etc.
How to Calculate Chronological Age in Months
Some assessments (particularly for infants and toddlers) report norms in total months rather than years-months-days. Once you have the Y;M;D result, convert it:
Whole months only: (Years × 12) + Months
Decimal months: (Years × 12) + Months + (Days ÷ 30.44)
Example: Age 6;8;24
Whole months: (6 × 12) + 8 = 80 months
Decimal: 72 + 8 + (24 ÷ 30.44) ≈ 80.79 months
Most standardized tests round down to the nearest complete month when the protocol specifies "age in months." Always check the test manual for the exact rounding rule.
How to Calculate Chronological Age in Excel
Excel's built-in DATEDIF function handles year/month/day separately. Assume the birth date is in cell A1 and the reference date is in B1:
Full years
=DATEDIF(A1, B1, "Y")Remaining months
=DATEDIF(A1, B1, "YM")Remaining days
=DATEDIF(A1, B1, "MD")Combined in one cell
=DATEDIF(A1,B1,"Y")&"y "&DATEDIF(A1,B1,"YM")&"m "&DATEDIF(A1,B1,"MD")&"d"Note: DATEDIF is undocumented in newer Excel versions but remains fully functional. Google Sheets supports the same syntax.
Common Mistakes to Avoid
✗ Using the wrong reference date
Use the test administration date, not today's date, when calculating age for a past assessment.
✗ Skipping the borrowing step
When the reference day is smaller than the birth day, you must borrow from the month count before subtracting days.
✗ Using a fixed 30-day month when borrowing
Use the actual number of days in the previous calendar month (28, 29, 30, or 31).
✗ Rounding the final days
Report the exact day count. Many norm tables are sensitive to day-level precision.
✗ Confusing chronological age with corrected age
Premature infants use corrected age (adjusted for weeks premature) for developmental norms. Chronological age is always counted from birth.
Frequently Asked Questions
How do you calculate chronological age?
Subtract the birth date from the reference date — work through years, months, and days in sequence, borrowing from the next larger unit whenever a subtraction goes negative. Express the result as Y;M;D.
What is the chronological age formula?
Chronological Age = Reference Date − Birth Date, expressed in years, months, and days. For total months: (years × 12) + months + (days ÷ 30.44).
How do you calculate chronological age in months?
Calculate age in Y;M;D first, then apply: total months = (years × 12) + months. Add days ÷ 30.44 for a decimal value. Most test protocols round down to the nearest whole month.
What does it mean to borrow when calculating age?
Borrowing means taking from the next larger unit when subtraction would produce a negative number. If the reference day (8) is less than the birth day (15), borrow 1 month and add that month's day count (e.g., 31 for May) to the reference day before subtracting.
Can I use Excel to calculate chronological age?
Yes. Use =DATEDIF(birth, reference, "Y") for years, =DATEDIF(birth, reference, "YM") for remaining months, and =DATEDIF(birth, reference, "MD") for remaining days. Works in both Excel and Google Sheets.
What is the difference between chronological age and developmental age?
Chronological age is the exact time since birth. Developmental age reflects skill level, which may be ahead of or behind chronological age. Standardized tests always use chronological age — never developmental age — to look up norm scores.
Why does exact chronological age matter in standardized testing?
Norm tables for assessments like WISC-V, GFTA-3, and Bayley-4 are divided into narrow age bands — sometimes only one month wide. An error of a few days can place the child in the wrong band, producing an incorrect standard score.
Skip the Math — Use the Free Calculator
WiseAgeCalc calculates exact chronological age in years, months, days, weeks, and total days instantly. No formulas, no borrowing steps required.
Related Guides
Child Chronological Age
Why exact age matters in child assessment and education.
Prematurity and Corrected Age
Chronological age versus corrected age for premature babies.
Age Calculator for Testing
Exact age for Pearson, Brigance, Bayley, and other assessments.
Age Calculator for Speech Therapy
How SLPs calculate age for GFTA-3, CELF-5, and PPVT-5.