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...
The birth date is provided by cell C3, theTODAY functionreturns today’s date, and “y” is entered for the interval to calculate age in complete years. =DATEDIF(C3,TODAY(),"y") This function is undocumented in Microsoft Excel due to a known issue with the “MD” unit (ignored in th...
Drag the Fill Handle down to copy the formula to the other cells. In the diagram below you can see that I have copied the formula and got my desired output. Read More: How to Calculate Age in Excel in Years and Months Method 6 – Using the DATEDIF and TODAY Functions to Calculate Age...
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 today is February 28, the...
TODAY(): This argument returns today’s date. Step 1: Select cell D5. 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 ...
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 ...
Step 3:Use the formula to calculate age in years, months, and days, similar to the Excel formula mentioned earlier. Make sure to replace the cell values. =DATEDIF(cell_with_birthdate, TODAY(), "Y") & " years, " & DATEDIF(cell_with_birthdate, TODAY(), "YM") & " months, " & ...
To calculate age in Excel, use the DATEDIF function and TODAY. You can also use the age formula further down to calculate a person’s exact age in years, months, and days. Enter the date of birth into cell A2.
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 ...
1.32 Calculate weekend/workday/specific weekday difference between two datetimes by Formula Helper If you want to quickly count the weekend, workdays or a specific weekday between two datetimes, Kutools for Excel’s Formula Helper group can help you.1...