Search results
Results From The WOW.Com Content Network
The easiest combination of an Excel formula and the mathematical operator division to calculate age is TODAY() and dividing the time to date by 365 to get a rough age of a person or object. However, you must also need a date of birth for human beings and starting date for objects or projects.
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.
Excel can help you calculate the age of a person in different ways. The table below shows common methods to do so, using the Date and time functions. To use these examples in Excel, drag to select the data in the table, then right-click the selection and pick Copy.
To calculate someone's age in years, use Excel's DATEDIF function. This function takes the date of birth as an input and then generates the age as an output. For this example, we'll use the following spreadsheet.
Here’s how to calculate age based on a date of birth in Excel with the “YEAR” function. In the cell, type the “equals” sign (=) and add opening brackets; Type the “YEAR” function and add another opening bracket; Type the “TODAY” function and close the brackets; Add a “minus” (-).
The formula is =DATEDIF (start_date, end_date, "Y"). The DATEDIF function calculates the difference between two dates. In this case, "start_date" is the date of birth, and "end_date" is the date you want to calculate the age from. The "Y" parameter tells Excel to return the result in years.
Learn a few easy ways to calculate age in Excel: how to get age from date of birth, age between two dates, exact age in years, months, days, and more. See how to make your own age calculator in Excel.