What is the formula for calculating age in Excel?

1. First open an Excel table, and then select the cells that need to be calculated.

#2. Select the cell in the age column with the mouse and right-click.

#3. Click on Format Cells in the pop-up window.

#4. Click the value under the number list in the cell format and set the number of decimal places to 0.

5. Select cell C2, enter the content in the quotation marks "=(today()-B2)/365", and then press the Enter key on the keyboard. Age can be derived.

#6. Then put the mouse on the lower right corner of C2 and pull down to get the age of other people.

For more Excel technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of What is the formula for calculating age in Excel?. For more information, please follow other related articles on the PHP Chinese website!