Author: Oscar Cronquist Article last updated on July 31, 2018

The PDURATION function calculates how many periods required by an investment to reach a given amount based on a percentage rate.

Formula in cell C7:


Excel Function Syntax



Rate Required. Rate is the interest rate per period.
Pv Required. Pv is the present amount of the investment.
Fv Required. Fv is the desired future amount of the investment.


The PDURATION function returns

  • #VALUE error if invalid data types are used.
  • #NUM error if argument values are invalid.

Positive values are required as arguments.

Equivalent formula

The following formula calculates the exact same thing as the PDURATION function.

Formula in cell C5:


This formula explains in depth how the PDURATION function works.