To get someone's age at a certain date, replace theTODAY()function in the formula with that specific date. For instance, if the particular date is in cell B2, use the formula below: =INT((B2-A2)/365) Copy Using this formula in Excel, which divides the difference in days between two...
How To Calculate Age in Excel Here’s how Excel can calculate DOB to age: In a cell, type in the “equals” sign (=) and the “DATEDIF” function. Select the cell with the date of birth. Add a comma and write the “TODAY” function. Add another comma and “y” in quotation mark...
Because the result of this age formula is a string, further calculations such as to return the average age are not possible. For this, each DATEDIF function for the year and month calculations could be entered in different columns, or the example using the YEARFRAC function could be used. C...
There are a couple of ways to calculate the age in years when you have the date of birth and the time for the age. Example:In the following dataset, the birth data is in column A, and the age date is in column B. Formula 1: The INT Function The first method is to count the da...
Note: The TODAY Function: TODAY() returns today’s date (6/13/2016 in our example) Try our AI Formula Generator Generate Calculate Rounded (Truncated) Age The previous answer was in decimal format (25.59 years). However, we generally would refer to this person as 25 years old, not 25.5...
You can also use the YEARFRAC function to calculate the age in Excel (in years) in the specified date range.Here is the formula:=INT(YEARFRAC(B1,TODAY()))The YEARFRAC function returns the number of years between the two specified dates and then the INT function returns only the integer ...
Normally, we can calculate a person’s age based on the birth date with a formula, but, have you ever considered calculating the age of his next birthday in Excel? Which means to calculate how old he is going to be in next birthday. This article, I will talk about some formulas for ...
=DATEDIF(B2,TODAY(),"M") ✕Remove Ads Press Enter and you'll see the age in months in the C2 cell. How to Calculate Age in Days Excel'sDATEDIFfunction is so powerful that you can use it to find someone's age in days as well. ...
=INT((TODAY()-B2)/365) Drawbacks:Using this age formula in Excel produces pretty accurate results, but not flawless. Dividing by the average number of days in a year works fine most of the time, but sometimes it gets the age wrong. For example, if someone was born on February 29 and...
=ArrayFormula(if(len(B3:B),(int(yearfrac(B3:B,today(),1))),)) The procedures mentioned in this post would be especially helpful for those who are managing employees, students, sports teams, etc. In case you want to calculate the age containing only year (and no months and days) for...