age using birthdate excel
So does it in Excel. Step 1: Enter current date in a blank cell, such as 2016/4/7 in Cell B2. Step 2: In another blank cell (says cell C2), enter the formula =INT((B2-A2)/365), and press the Enter key. Method B: Convert birthdate to age with DATEDIF function. Some would like to apply the DATEDIF function to calculate the age. Enter the formula =DATEDIF(A2,NOW(),y) in a blank cell, it calculates the age immediately after pressing the Enter key. Method C: Convert birthdate to age with ROUNDDOWN function. Another function to convert the birth date to age is =ROUNDDOWN(YEARFRAC(A2, TODAY(), 1), 0), which will figure out a standard age, such as 27. Method D: Convert birthdate to exact age with DATEDIF function. The following spreadsheet shows the Excel Yearfrac function, used to calculate the age, on 01/01/2017, of an individual who was born on 03/03/1960: The function in cell B3 of the above spreadsheet returns the value 56.82777778. I.e. on the date 01/01/2017, a person who was born on 03/03/1960, was 56 years old. One use for Excel's DATEDIF function is to calculate a person's current age. In the following formula, the DATEDIF function is used to determine a person's current age in years, months and days. =DATEDIF (E1, TODAY( ),Y) &  Years,  & DATEDIF (E1, TODAY( ),YM) &. March 31, 2015. 1  Two of the most common ways to calculate age from a birth date in Excel are to use the DATEDIF function and to use standard arithmetic operators on date fields. When you use date values in an Excel spreadsheet, it's helpful to understand how date values are stored in Excel and the difference between character strings and date fields. Age = DateDiff(yyyy, Birthdate, Date) to calculate age, but this doesn't quite work. If the birth date hasn't yet occurred this year, the Age value will be off by 1. For example, imagine your birthday is December 31, and you were born in 1950. If today is October 1, 1997, subtracting the year portions of the two dates (1997 – 1950) would indicate that you were 47 years old. Cell AR2 held the date of birth 7/28/1966. Once your formula was entered into GD2, it accurately calculated the age to be 44. However, the correct date of birth in AR2 should be 7/29/1965. I went back to AR2 and changed the date of birth from 7/28/1966 to 7/29/1965 -- the result in GD2 should have been 45. Divide the number of days by 365.25 and take the integer value of the result to get the number of whole years between the two dates. For example, if cell A1 contains a birth date, you can calculate age by entering =INT((TODAY()-A1)/365.25) in a spreadsheet cell. Hi, I've been using the formula below to calculate age. Works fine but I'm wondering if TODAY changes every day. In other words, yesterday I was 28. Today is my birthday, so my age will change to 29. =INT((TODAY()-DY13)/365.25) Calculate Your Current Age with DATEDIF. One use for Excel's DATEDIF function is to calculate a person's current age. In the following formula, the DATEDIF function is used to determine a person's current age in years, months and days. Note: To make the formula easier to work with, the person's birth date is entered into cell E1 of the worksheet. Insert a blank column next to the column that contains the DOB data, if needed. 3. Click in the first blank cell of the Age column and type the following formula: =DATEDIF(C2,TODAY(),Y) Replace C2 with the cell reference of the first DOB cell, and then press Enter.. For example, if your DOB data is in column C, and the first date is in row 2, the cell reference is C2. This expression calculates the difference between the date in C2 and the current date returned by the Today() function. The “Y” in the example tells Excel to return the year value.
Enter current date in a blank cell, such as 2016/4/7 in Cell B2, in another blank cell (says cell C2), enter the formula =INT((B2-A2)/365), and press the Enter key.