days360 function calculates age

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

C4 cell is the final effect, so the age can be calculated.

The above is the detailed content of days360 function calculates age. For more information, please follow other related articles on the PHP Chinese website!