ExcelExcel 2013+
PDURATION function in Excel
Returns the number of periods required by an investment to reach a specified value
=PDURATION(rate, pv, fv)PDURATION syntax and parameters
Three arguments, three required.
- ratenumberRequired
Rate is the interest rate per period.
- pvnumberRequired
Pv is the present value of the investment.
- fvnumberRequired
Fv is the desired future value of the investment.
PDURATION examples
Formulas you'll actually reuse.
Years for $10,000 to double at 4%:
=PDURATION(4%, 10000, 20000)Result
17.67Months for $5,000 to reach $6,000 at 7% a year, compounded monthly:
=PDURATION(7%/12, 5000, 6000)Result
31.35
PDURATION in Google Sheets
Same name — your formula ports as-is.
Try PDURATION in the playground
Edit the example — nothing to install.
Preloaded with the PDURATION formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets