How do I calculate age from a specific date in Excel?

How do I calculate age from a specific date in Excel?

Calculate age on a specific or future date with formula Select a blank cell for locating the age, then enter formula =DATEDIF(A2,B2,"y") into the Formula Bar, then press the Enter key. Note: In the formula, A2 contains the person's date of birth, B2 is the specific date or future date. You can change them as you need.

What is the formula to calculate age?

To calculate the exact age of a person, you want to calculate the difference between the current date (or any other desired date) and the birth date. You might think that you could simply take the difference in days between the current date and the birth date divided by 365: (Current Date – Birth Date) / 365.

Can Excel calculate age based on birthdate?

To calculate the age of a person in Excel, use the DATEDIF function and the TODAY function. … The DATEDIF function below calculates the age of a person. Note: fill in "y" for the third argument to get the number of complete years between the date of birth and today's date.