Calculating Age in Excel
Microsoft Excel provides separate functions for various mathematical operations. Nowadays, Microsoft Excel is widely used by large and various organizations. Using formulas one can calculate the statistical functions quickly and effectively. To calculate the age in excel, Excel functions and date of birth is used. Using this function one can find the persons current age till date or given specified time.
Here in this tutorial, let’s discuss how to calculate the age of a person using formulas.
Calculating the Age of a Person till date using Formula
To calculate the age of a person till date, enter the date of birth to find the elapsed time between the date and till now time.
STEP 1: Enter the date of birth in cell B1.
STEP 2: Enter the current date in cell B2.
STEP 3: Select the cell B4 where the result wants to display and type the formula as =DATEDIF (B1, B2,”y”)
The above formula won’t present default in Excel functions. To use this one has to remember this formula. There are three arguments present.
=DATEDIF (start_date, end_date, unit)
start _date: It indicates the starting date of the period.
End_date: It indicates the end date of the value.
Unit: It represents the type of result the users gets.
Calculating the today’s date from Date of Birth
To calculate the today’s date from the given date of birth, following steps are followed
STEP 1: Enter the date of birth in Cell B1.
STEP 2: Select the cell B2 and type the formula as =TODAY()
Calculating the age of a person without today’s date
To calculate the age of a person without using current date, following steps are followed.
STEP 1: Enter the date of birth in cell B1.
STEP 2: Enter the formula in the cell B2 as =DATEDIF (B1, TODAY (),”y”)
The current age of a person will display in the result box.
Calculating the age of a person on a particular date
To calculate the age of a person on a particular date, following steps are used.
STEP 1: Enter the date of birth in the cell B1.
STEP 2: Select the cell B2 and enter the formula as =DATEDIF(B1,DATE (2022,1,1),”y”)
Calculating the age of a person based on days, month and year
To calculate the age of a person based on days, month and year following steps are followed.
STEP 1: Enter the date of birth in cell B1.
STEP 2: Select the cell B2 and enter the today’s date.
STEP 3: Select the cell B3, and enter the formula as =DATEDIF(B1,B2,”y”)&”y”& DATEDIF(B1,B2,”ym”)&”m”&DATEDIF(B1,B2,”md”)&”d”
From the above table in the cell B3, the age of a person is calculated in a year month and day based pattern.
Summary
From the above tutorial, the various formulas to find the age of a person is calculated.