Calculate Age on Specific Date in Excel To calculate the age on a specific date in Excel, follow these steps: Step 1:Enter the birthdate and specific date in cells. Step 2:Use the formula to calculate age in years, months, and days until a specified date. Make sure to replace the cel...
Drag the Fill Handle down to copy the formula to the other cells. Read More: How to Calculate Age in Excel in dd/mm/yyyy Method 4 – Using the DATEDIF Formula to Calculate Age on a Specific Date in Excel This function has three parameters: Start_date, end_date, and format. Steps: ...
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...
Reasons for this include, wanting to calculate someone’s age at a given date, or wanting to calculate the time taken to deliver a project. The following formula calculates age in Excel using the start date in cell C5 and the end date in cell D2. The reference to the end date is made...
So, here's an improved YEARFRAC formula to calculate age in Excel: =ROUNDDOWN(YEARFRAC(B2, TODAY(), 1), 0) Calculate age in Excel with DATEDIF One more way to convert date of birth to age in Excel is using theDATEDIFfunction:
Press “Enter” to calculate age in Excel from a birthday. Click and drag the formula if you want to apply it to other cells. The complete formula will be: =DATEDIF(B2, TODAY(), "y") This formula calculates the difference in years between the date of birth (cell B2) and the current...
The steps to calculate the age in years by using the DATEDIF excel function are listed as follows: Enter the following formula in cell C2. “=DATEDIF(A2,B2,“Y”)” Note:For details related to the DATEDIF function, refer to the “description of the DATEDIF function” given at the end ...
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 ...
Drag down to apply the formula to other cells. Release the mouse — your other ages will calculate. So, for my example above, where the dates are in column B, here would be my finalExcel Formula: TRUNC(YEARFRAC(B2,TODAY())) How to Calculate Current Age in Years and Months in Excel ...