How to use the formula to calculate age in excel

The specific formula is: =(today()-B2)/365. B2 in the formula is the date of birth column in the table. It is actually based on your own table.

The specific usage method is as follows:

Example: Calculate the age of the people in the table below

1. Select Enter the function in the cell to output the result = (today()-B2)/365 and press Enter to get the age:

2. Sometimes the following situations occur:

3. We only need to select the column of the output result, right-click the mouse and select "Format Cells" and set the number of decimal places in the numerical option to 0.

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

The above is the detailed content of How to use the formula to calculate age in excel. For more information, please follow other related articles on the PHP Chinese website!