Practice free

PDURATION function

PDURATION returns how many periods it takes for money to grow from one amount to another at a fixed rate, with no regular payments. It is simpler than NPER for lump sums.

Example

Read it as a sentence: find how many periods it takes an investment to grow from 2000 to 2200 at 2.5% per period, which gives 3.85986616262266.

Practice this in the app

Syntax

PDURATION(rate, pv, fv)

rate (required)
Interest rate per period.
pv (required)
Present value.
fv (required)
Future value wanted.

Returns: Periods needed for an investment to reach a target value.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=PDURATION(0.05,1000,2000) 14.20669908 Double at 5%
=PDURATION(0.05,2000,1000) -14.20669908 Fv < pv
=PDURATION("0.05","1000","2000") 14.20669908 Text number
=PDURATION({0.05,0.1},1000,2000) 14.20669908 Spill
=PDURATION(0,1000,2000) #NUM! Rate 0
=PDURATION(-0.05,1000,2000) #NUM! Rate negative
=PDURATION(0.05,0,2000) #NUM! Pv 0
=PDURATION(0.05,-1000,-2000) #NUM! Negative values

Watch out for

  • rate, pv and fv must all be positive.

Where it works

Excel
PDURATION arrived in Excel 2013. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Financial functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .