# Excel: How to Calculate Age on a Specific Date

You can use the following formulas to calculate the age of an individual on a specific date based on their date of birth:

Formula 1: Calculate Age in Years (e.g. 60 years)

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

Formula 2: Calculate Age in Decimal Years (e.g. 60.372 years)

`=YEARFRAC(A2, B2)`

Formula 3: Calculate Age in Years, Months, Days (e.g. 60 years, 4 months, 14 days)

`=DATEDIF(A2,B2,"y")&" years, "&DATEDIF(A2,B2,"ym")&" months, "&DATEDIF(A2,B2,"md")&" days"`

Each formula assumes that the birth date is located in cell A2 and the specific date of interest is in cell B2.

The following examples show how to use each formula in practice.

## Example 1: Calculate Age in Years

We can type the following formula into cell C2 to calculate the age of an individual in years on the date of 5/15/2040, assuming they were born on 1/1/1980:

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

The following screenshot shows how to use this formula in practice: We can see that an individual who was born on 1/1/1980 will be 60 years old on 5/15/2040.

## Example 2: Calculate Age in Decimal Years

We can type the following formula into cell C2 to calculate the age of an individual in decimal years on the date of 5/15/2040, assuming they were born on 1/1/1980:

`=YEARFRAC(A2, B2)`

The following screenshot shows how to use this formula in practice: We can see that an individual who was born on 1/1/1980 will be 60.372 years old on 5/15/2040.

## Example 3: Calculate Age in Years, Months, Days

We can type the following formula into cell C2 to calculate the age of an individual in years, months and days on the date of 5/15/2040, assuming they were born on 1/1/1980:

`=DATEDIF(A2,B2,"y")&" years, "&DATEDIF(A2,B2,"ym")&" months, "&DATEDIF(A2,B2,"md")&" days"`

The following screenshot shows how to use this formula in practice: We can see that an individual who was born on 1/1/1980 will be 60 years, 4 months and 14 days old on 5/15/2040.