Functions
PDURATION
Periods required to reach a value
Try it
When to use it
When should I use PDURATION?
Use PDURATION to find out how many compounding periods an investment needs to grow from a present value to a target future value at a given rate — useful for goal-based savings planning.
Used in
Syntax
PDURATION(rate, pv, fv)Examples
=PDURATION(0.25,10,15) // => 1.8170594925112884
=PDURATION(0.75,2,15) // => 3.6005113936756485