How to Calculate Age in Microsoft Excel 2016 ?

One of the simplest ways to calculate the age of a person in Microsoft Excel 2016 by providing the date of birth as input is using the DATEDIF formula.

How to Calculate Age in Microsoft Excel 2016 ?

Assume that the Cell A1 contains the date of birth of the person and you need to calculate the age and display it in the cell A2 , your formula would like this

=DATEDIF(A1,TODAY(),”y”)

image

Alternatively , you can also use NOW() instead of TODAY() in the formula.

=DATEDIF(A1,NOW(),”y”)

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021