Enter the following formula below: =YEARFRAC(C5,TODAY()) Press ENTER. Formula Breakdown TODAY(): This function returns today’s date. =YEARFRAC(C5,TODAY()): This final combined function represents the current age in the following data set. Step 2: You will see the first person’s current...
Press Enter to get the age. How Does the Formula Work? TODAY(): The TODAY function returns the current date. DATEDIF(C5,TODAY(),”Y”): The DATEDIF function returns the years between the date in cell C5 and the current date. Drag the Fill Handle to copy the formula. Below you can ...
Here’s a step-by-step guide on how to create an age calculator in Excel: Create a cell for the date of birth. Create another section for the current age. In the cell for the current age, add the formula: =DATEDIF($B$1,TODAY(),"y") If you want to calculate a person’s age...
This option will calculate the current age for the selected date of birth. In other words, it will compare a person's birthday to the present day. Calculate age on aSpecific date. This option lets you get Excel formula to calculate age between two dates: the date of birth and any date...
If the age is displayed as a negative value in the Age Calculator, it usually indicates an issue with the order of the dates used in the calculation. The formula subtracts the birth date from the current date or specific date to calculate the age. However, if the birth date is entered ...
How to Calculate Current Age from Date of Birth in Excel Using YEARFRAC If you want to calculate someone’s current age from their date of birth, you need to know what is the formula for calculating their age. Quite often, the best choice is to use theYEARFRACfunction. This returns the ...
Assuming a birthdate is in cell B2, the formula to calculate age in years goes as follows: =(TODAY()-B2)/365 The first part of the formula (TODAY()-B2) returns the difference between the current date and date of birth is days, and then you divide that number by 365 to get the ...
Calculate an Age With the DATEDIF Function One use forExcel's DATEDIF functionis to calculate a person's current age. If you don't feel like dragging out a calendar, a simple spreadsheet formula can come to the rescue. Alternatively, use the function to compute the difference between any tw...
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 ...
Try our AI Formula Generator 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.59 years old. You can use the INT or TRUNC Functions to simply trim off of decimals (note: yo...