How to calculate age in excel
- 王林Original
- 2020-04-23 09:43:477838browse
Use the mouse to select the age column, right-click the mouse and select "Format Cells"
In the pop-up dialog In the box, set the category to "Numeric" and the number of decimal places to "0"
Enter the formula "=(TODAY()-" in cell D2 of the age column C2)/365", meaning: (today - date of birth)/365 days
Press Enter to complete the automatic calculation.
Recommended tutorial: excel tutorial
The above is the detailed content of How 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：How to filter the same data in two tablesNext article：How to filter the same data in two tables