81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value.

How To Use in Sheets

DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.