To calculate the age of a person in Excel, use DATEDIF and TODAY. The DATEDIF function has three parameters.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to calculate age in Excel
1. Enter your date of birth in cell A2.
2. Enter the TODAY function in cell B2 to return the current date.
3. The DATEDIF function below calculates a person’s age.
Note: Enter “y” for the third parameter to get the full number of years between the date of birth and the current date.
4. Calculate a person’s age without displaying the current date.
5. Calculate the age of a person on a specific date.
Note: the DATE function accepts three parameters: year, month, and day.
6. Calculate a person’s age in years, months, and days.
Note: Enter “ym” for the third parameter to skip the year and get the number of months between the two dates. Enter “md” for the third parameter to skip the month and get the number of days between the two. Use the & operator to concatenate strings.
