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

ArgumentRequired?What it does
rateYesThe growth rate per period.
pvYesThe starting value.
fvYesThe 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)
AB
1RatePeriods
25% a year9.63
30.4% a month117.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

Kyle Stott

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.