Method 2 – Combining DATEDIF and TODAY Functions to Calculate Current Age If you want to know a person’s actual age, you can find out how many years, months, and days have passed since their birth. The DATEDIF function should be combined into a single formula as shown below in step 1...
Select the cell where you want to calculate the age. Here I selected cell D5. In cell D5 enter the following formula. =DATEDIF(C5,TODAY(),"Y") Press Enter to get the age. How Does the Formula Work? TODAY(): The TODAY function returns the current date. DATEDIF(C5,TODAY(),”Y”...
For this example of how to calculate current age in Excel, we’ll be using the worksheet below: Here’s a step-by-step guide for how to convert DOB to age in Excel: In a cell, type in the “equals” sign (=) and the “DATEDIF” function. Select the cell with the date of birth...
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 ...
Calculate Current Age in Years, Months, and Days For illustrative purposes, let's consider the table below that contains the date of birth for five members of the club. To calculate their ages, please follow the steps outlined below.
In this age formula, the two dates are provided using the date of birth in column C and the TODAY function for the current date. The first DATEDIF uses “y” for the unit argument to calculate age in years. The second DATEDIF function uses the unit of “ym” to return the date differ...
Example #1–DATEDIF to Calculate Age in Completed Years The following image shows two dates in each row. We want to calculate the time gap between the past date (column A) and the current date (column B). Use the DATEDIF excel function to calculate the time gap (age) in completed years...
2.23 Add working hours to a date excluding weekend and holiday 2.3 Add or subtract date/time by Kutools for Excel 2.4 Extension 2.41 Check or highlight if a date is expired 2.42 Return the end of current month/first day of next month 3. Calculate age 3.1 Calculate age ba...
How to Calculate Age in Years, Months, and Days at the Same Time How to Calculate Age on a Specific Date To find someone or something's age in Microsoft Excel, you canuse a functionthat displays the age in years, months, and even days. We'll show you how to use this function in ...
Basic Excel formula for age in years How do you normally figure out someone's age? Simply by subtracting the birth date from the current date. This conventional age formula can also be used in Excel. Assuming a birthdate is in cell B2, the formula to calculate age in years goes as foll...