Free online age calculator. Enter your date of birth to calculate the exact age in years, months, and days. Also find out the total days lived, weeks, next birthday countdown, day of birth, and zodiac sign.
Your exact age is:
Age in years:
Age in months:
Age in weeks:
Age in days:
Day of birth:
Next birthday:
Zodiac sign:
You might be interested in:
An age calculator uses chronological age to measure the time elapsed from a person's date of birth to today or another as-of date. It expresses the result in years, months, and days—the standard way to describe how long a person has lived.
An age calculator returns chronological age, which is based on elapsed time. In contrast, biological age reflects the condition of an individual's body and may be influenced by genetics and lifestyle habits. Two people with the same chronological age can therefore have different biological ages.
If you need an age calculator in Microsoft Excel, you can use the DATEDIF function to calculate years, months, and days from a date of birth. This can be useful for tracking, analysis, or reports:
To create an age calculator in an Excel cell, use the following formula: =DATEDIF(Date_of_Birth, TODAY(), "Y") & " years, " & DATEDIF(Date_of_Birth, TODAY(), "YM") & " months, " & DATEDIF(Date_of_Birth, TODAY(), "MD") & " days"
Replace "Date_of_Birth" with the reference to the cell containing the individual's date of birth. Excel's DATEDIF function calculates the difference between the date of birth and the current date (TODAY()), returning the age in years, months, and days as a text string.
Let's say the date of birth is in cell A2. The age calculator formula would look like this: =DATEDIF(A2, TODAY(), "Y") & " years, " & DATEDIF(A2, TODAY(), "YM") & " months, " & DATEDIF(A2, TODAY(), "MD") & " days"
By entering this formula in an Excel cell, it will display the person's age in years, months, and days, using the current date for the calculation. This formula allows you to obtain a person's exact age quickly and accurately in Microsoft Excel for any date of birth.