days360 function calculates age
- angryTomOriginal
- 2019-10-26 12:02:518536browse
days360 function calculates age
There are many ways to calculate age in excel. Here we introduce the days360 function. How to calculate age.
Recommended tutorial: excel tutorial
days360 function format:
days360(开始时间, 结束时间)
1. First, enter the formula # in cell C2 ##
=DAYS360(B2,TODAY())today() is also a function used to calculate the current time.
2. This is the age displayed in days. We divide it by 365
Enter in cell c3=DAYS360(B3,TODAY())/365
3. This is the age display with decimals, we can set the cell format
The above is the detailed content of days360 function calculates age. 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