Open the excel table and enter the date of birth in the cell in column A. See column A below for specific data. Enter the age calculation formula in cell B 1: =DATEDIF(A 1, TODAY (), y). Click [Enter] to generate the calculation result, and calculate the generated age according to the birthday date.
First open the Excel program, and then open the document to calculate the age by birthday. Then, select the cell where you want to store the birthday data. Then, click Cell Format on the right-click menu. Then, click to open the Value option.
Then, you can see the results in the pop-up window. Excel has a year of birth. How to calculate the age? The year of birth is known in the Excel worksheet, so the age is calculated by subtracting the year of birth from the current year.
The function we use here is the today function. The specific formula is = (Today () -B2)/365. B2 in the formula is the column of birth date in the table, which is actually based on our own table.
How to extract age from birth date in excel table? Hello, I saw your question and am sorting out the answers. Please wait a moment ~ Answer: Enter the age calculation formula in the cell: =DATEDIF(A 1, TODAY (), y).