Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
PDURATION
PDURATION calculates how long it takes for an investment to grow from a present value to a target future value at a given periodic rate, assuming continuous compounding at that rate. It is useful for quick savings-goal planning.
Excel
=PDURATION(0.06,1000,2000)Google Sheets
=PDURATION(0.06,1000,2000)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Rate | PV | FV |
| 0.06 | 1000 | 2000 |
| 0.08 | 500 | 1000 |
| 0.05 | 2000 | 3000 |
| 0.1 | 1000 | 5000 |
=PDURATION(0.06,1000,2000)→11.8956610459
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the periodic interest rate, the current value of the investment, and the target future value.
- 2Enter =PDURATION(rate, pv, fv) to get the number of periods needed.
- 3Interpret the unit as the same period as your rate (years if annual, months if monthly).
Need a version for your data?
Try: “How many years will it take for $1,000 to double at a 6% annual rate?”