# Calculate age in excel Published

on

Calculate age in excel Use DATEDIF or TODAY in calculating a person’s age in Excel formula. There are three arguments in the DATEDIF function. You can easily calculate age in Excel using a combination of Excel features and date of birth. You can calculate the age between the current date and the specified time.

Also, in other situations such as determining project duration or service tenure, the technique shown here can be used.

1.Enter the date of birth or dob into cell A1

2. Enter TODAY formula in the B2 cell to return the current date.

``=TODAY()``

3. The following DATEDIF formula calculates a person’s age. For a third argument, enter “y” to get the full number of years from the date of birth to the date today.

``=DATEDIF(A2,B2,"y")``

### Calculate a person’s age without display.

4.Calculate a person’s age without today’s date display.

``=DATEDIF(A2,TODAY(),"y")``
``=DATEDIF(A2,B2,"y")&"Y "&DATEDIF(A2,B2,"ym")&"M "&DATEDIF(A2,B2,"md")&"D"``