How to Calculate Age from Date of Birth
Updated
Exam notices, job applications and insurance forms often ask for your age on a particular date, in years, months and days. Working it out by hand is easy to get wrong. Here's the method, with the special cases.
The method
Count whole years first, then whole months, then the remaining days. Start from the date of birth, step forward one year at a time until the next step would pass the target date, then do the same with months, and count the days left over.
A worked example
Born on 14 March 1998, what is your age on 19 November 2026? From 14 March 1998 to 14 March 2026 is 28 years. From 14 March 2026 to 14 November 2026 is 8 months. From 14 November to 19 November is 5 days. The age is 28 years, 8 months and 5 days.
Age on a cut-off date
Recruitment and exam notices usually fix a cut-off date, such as 1 August of the exam year, and set a minimum and maximum age on that date. Calculate your age on the cut-off date, not today. Check the notice too, as some say 'not less than 18 years' and others 'born on or after' a date, which can differ by a day.
Born on 29 February
In years that aren't leap years, there's no 29 February. The common convention, also used by this site's calculator, is to count the birthday on 28 February in those years. Some rules use 1 March instead, so check if the exact day matters.
Days lived and the next birthday
Total days lived is simply the number of days between the date of birth and today. The countdown to your next birthday is the days from today to the next date with your birth day and month.
In Excel
With the date of birth in A1: years =DATEDIF(A1, TODAY(), "Y"), extra months =DATEDIF(A1, TODAY(), "YM"), extra days =DATEDIF(A1, TODAY(), "MD"). Replace TODAY() with a cell holding a cut-off date to get the age on that date.
Try it
The Age Calculator gives your exact age on today's date or any date you choose, with total days and weeks lived, the weekday you were born on, and the days to your next birthday.