How To Calculate Age From Date Of Birth With Formulas In Google Sheets

Calculate age from date of birth with formulas in Google Sheets

We can calculate the age of people on a Google Sheet page as follows: 1] Using the DATEDIF formula The syntax for the DATEDIF formula is as follows: Where is the cell number of the first cell with the date of birth mentioned in the column of date of birth. Eg. If you are creating the list of ages of the individuals in column C and the cell number of the first cell in the column of cells mentioning the dates of birth is B3, the formula would become as follows:

You would have to copy-paste this formula to cell C3 and press Enter to execute the operation. Click on any other blank cell and then click back on C3. A dot would appear on the right-bottom of the C3 cell. Use it to pull down the formula to corresponding last cell in column B, which mentions the date of birth. Eg. If the last cell in column B which mentions the date of birth is B8, pull the formula C8.

Interestingly, the DATEDIF formula has an option if you wish to get the exact number of years, months, and days corresponding to the dates of birth. The syntax would be: Eg. In the example mentioned above, the formula would become as follows:  

Some users might find it difficult to pull the formula across cells. 2] Using the Array formula Unlike the DATEDIF formula, the Array formula requires you to mention all the details in the formula itself, thus making it easier to use. The syntax for the Array formula is as follows: Where is the cell number of the first cell with the date of birth mentioned in the column of date of birth and is the cell number of the last cell with the date of birth mentioned in the column of date of birth. Eg. If the dates of birth are listed in column B from B3 to B8, the formula will become:

If you wish to create the formula for an infinite number of rows, the syntax would be: Eg. In the case mentioned above, the formula would become as follows: The procedures mentioned in this post would be especially helpful for those who are managing employees, students, sports teams, etc. Hope it helps!