Home >Topics >excel >How to use the formula to calculate age in excel

How to use the formula to calculate age in excel

尚
Original
2019-06-14 11:52:5753268browse

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

How to use the formula to calculate age in excel

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

How to use the formula to calculate age in excel

2. Sometimes the following situations occur:

1How to use the formula to calculate age in excel

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.

How to use the formula to calculate age in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:excel function mod usageNext article:excel function mod usage