Excel: Calculate the age from the birthday

Excel also calculates the age of people or objects for you and thus the spreadsheet can do a lot of work for you. In this way you will never miss another milestone birthday and you are always up to date with your inventory.

Let Excel calculate the age - so it works

Latest videos

Get age calculated in Excel

Excel spreadsheet with automatic age calculation

Before Excel can do the work of calculating the age of your employees in the future, you first have to invest a little time: You create a file with all the dates of birth. In our example, we have created a small company file with five employees.

• You need three columns for the table. The names are listed in the first column. Enter the respective date of birth in the second column. The age of the employees is shown in the third column later.
• In the example, the names were recorded in column B. Behind it, in column C there are the corresponding dates of birth.
• The corresponding formula is entered in column D. Excel then calculates the respective date of birth and automatically displays it behind the data record. The formula is:
• = DATEDIF ( C3 ; TODAY (); "Y")
• Important: In the formula, enter the cell that contains the date of birth. In the example, this is cell C3.
• After entering the formula, transfer it to the other records. To do this, go to the small black square at the bottom right of the cell border.
• Then drag the formula down to the last employee.
• In column C, Excel now lists the age of all persons entered.

CHIP job market

In our CHIP job market you will find thousands of current jobs in the digital world. Whether as a software developer or marketing expert, at Microsoft or Amazon - we cover the entire breadth of the German tech world. And if you want to start one of these jobs as a career changer, distance learning is worthwhile. Request an information brochure about the current distance learning courses from ILS, Germany's largest distance learning school.

Now read on the next page how to insert or exchange columns in Excel.