Current Age

Find the age of a person based on the birth date and the current date, the time to find the difference, convert the result to format in years.

Normally databases include the general data of a person, including those general data is the date of birth, a classic requested operation is to calculate the age of the person to the current date; In Excel we can make a small operation that allows us to calculate the age of a very simple way.

 

For this, we need to first perform a subtraction of the current date minus date of birth, the result is in a numeric format, in this numerical result we apply a suitable format which would convert it to a date which only use the year.