Traditional Culture Encyclopedia - Traditional stories - Jiangsu drug bidding How to view distribution companies

Jiangsu drug bidding How to view distribution companies

Suggestion: TRUNC ((DAYS360 (″1998/6/1″, ″2001/12/31″))/360, 0)", the formula DAYS360 (″1998/6/1″, ″2001/12/31″) to calculate the number of days of the difference between the two dates, divided by 360 to calculate the year of the difference in dates (decimal). The last TRUNC function will be (DAYS360 (A1, B1) / 360 of the results of the calculation of the fractional part of the truncation, which results in the "real age". If the results need to retain a decimal, just modify the formula as "=