Returns the number of periods required for an investment to reach a specified value.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
PDURATION(rate, pv, fv)The PDURATION function calculates the number of periods needed for an investment to reach a target future value at a constant interest rate. It is useful for financial planning when you need to determine how long it will take for an initial investment to grow to a specific amount.
=PDURATION(0.05, 1000, 2000)Result: 14.2067
Calculates the number of periods required for 1000 to grow to 2000 at a 5% interest rate.
If the rate is 0, the function will return a #NUM! error because the investment value will never change.