INT((D5-C5)/365): The INT function returns the decimal number as an integer. Drag the Fill Handle down to copy the formula. You can see that I have copied the formula to the other cells. Read More: How to Calculate Age Between Two Dates in Excel Method 2 – Using the IF Formula...
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...
Method 4 – Using YEARFRAC Function to Calculate Age in Excel Steps: Select cell D5. Enter the following formula: =YEARFRAC(C5,TODAY(),1) In the YEARFRAC function, we used C5 as the start date, the TODAY function as the end date, and 1 as a basis. Press ENTER to get the age valu...
The age calculator feature in Excel is a useful tool that allows you to calculate the age of a person. In this guide, we will walk you through the process of using formulas to calculate age in Excel, both in years, months, and days, as well as on a specific date. In addition, we ...
=DATEDIF(C3,TODAY(),"y") This function is undocumented in Microsoft Excel due to a known issue with the “MD” unit (ignored in this tutorial, so no worries). Because of this, no assistance is provided as you type the formula on the worksheet. ...
=(YEAR(TODAY())-YEAR(B2)) This formula finds the age in the current date. If you want to use a specific date instead, you can use the cell reference for the date instead of the “TODAY” function. Wrapping Up Calculating age in Excel is a fundamental task that can be accomplished us...
Note that the TODAY function is volatile and its value would change every day whenever you open the workbook or there is a change in it. If you want to keep the result as is, convert the formula result to a static value.Download the Excel Age Calculator Template...
Looking to effortlessly calculate ages up to today or any given date and present them in diverse formats such as years, months, weeks, days, or a year + month + day combination? Kutools for Excel simplifies this task! No need for manual formula entries – Kutools streamlines the entire pro...
=DATEDIF(B2,TODAY(),"M") Press Enter and you'll see the age in months in the C2 cell. How to Calculate Age in Days Excel'sDATEDIFfunction is so powerful that you can use it to find someone's age in days as well. To show you a demonstration, we'll use the following spreadsheet...
Note: The TODAY Function: TODAY() returns today’s date (6/13/2016 in our example) Try our AI Formula Generator Generate 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.5...