Microsoft Excel has numerous functions and formulas to make your work easier. This also includes a function that can calculate the difference between two data. To use this function to calculate the age, simply follow our tips + tricks article. In addition, we will show you how you can also display your age in months and days.
Calculate the age from a date of birth with Excel
If you have a list of different dates of birth, you can easily use Excel to calculate the age using a built-in function. This calculates the difference between the current date with the = TODAY () function and the birthday. How exactly you have to enter the formula, read in the following.
As in our example, you can also use the = DATEDIF () function to calculate the age of your friends or co-workers. The formula is structured as follows:
=DATEDIF(Startdatum;Enddatum;"Zeiteinheit")
As the start date, select the cell with the first date of birth , e.g. here for Max B3, as the end date today using the = TODAY () function and as the time unit you have several options. For the age in years, select " Y " instead of "Time unit", which stands for Years . This results in the following function:
=DATEDIF(B3;HEUTE();"Y")
With this, Excel calculates your age from the difference between your date of birth and today's date. If you want to use the function on the entire data, you can do this easily by dragging the green selection box downwards. To do this, position the mouse pointer in the lower right corner so that it is displayed as a plus sign (+) and drag the fill handle down to the last cell that you want to calculate. When you release the mouse button, Excel automatically calculates the age for everyone on the list..
The output is in years, but other time units are of course also possible:
| abbreviation | Time unit |
| Y | years |
| M. | months |
| D. | Days |
| MD | Difference in days. Months and years are ignored.
|
| YM | Difference in months. Years and days are ignored. |
| YD | Difference in days. Years are ignored. |
| abbreviation | Time unit |
| Y | years |
| M. | months |
| D. | Days |
| MD | Difference in days. Months and years are ignored.
|
| YM | Difference in months. Years and days are ignored. |
| YD | Difference in days. Years are ignored. |
Calculate the age with Excel in years, months and days
If you would like to receive even more detailed information about the age, you can also request the years, months and days of the age. To do this, simply use the well-known = DATEDIF () function and repeat it for years, months and days within a cell. In between you just add filler text so that the whole thing looks better.
The following function gives you the exact age:
=DATEDIF(B3;HEUTE();"y") & " Jahre, " & DATEDIF(B3;HEUTE();"YM") & " Monate und " & DATEDIF(B3;HEUTE();"MD") & " Tage"
The commercial AND (&) combines the individual functions into an overall function. We have also added "years", "months" and "days" as filler words so that not only the numbers are output. Using our example, the exact age of Max can be calculated..
