PDURATION Function
Calculates how long it takes an investment to grow to a target.
Category
Financial
Available in
Excel 2013+, Microsoft 365
Returns
A number of periods
Want to practice PDURATION in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
PDURATION returns the number of periods needed for a lump sum to reach a target value at a fixed growth rate — with no extra deposits.
The answer's units match the rate's: annual rate, years; monthly rate, months.
Syntax
=PDURATION(rate, pv, fv) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| rate | Yes | The growth rate per period. |
| pv | Yes | The starting value. |
| fv | Yes | The target value. |
Examples
Example 1 — Time to reach a target
How long until Northstar's $250,000 reserve reaches $400,000?
B2fx=PDURATION(5%,250000,400000)
| A | B | |
|---|---|---|
| 1 | Rate | Periods |
| 2 | 5% a year | 9.63 |
| 3 | 0.4% a month | 117.74 |
Just under 9 years and 8 months at 5% a year.
Common mistakes
- #NUM! error. All three arguments must be positive.
- You're adding deposits too. PDURATION ignores regular payments — use NPER for that.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.