Summary

The Excel PDURATION function returns the number of periods required for an investment to reach a specified value at a constant rate. Microsoft defines it as a time-solver for compound growth, so its role is similar to asking "how long will this take?" under a fixed rate assumption.

That makes PDURATION useful when the unknown is time rather than present value, future value, or growth rate. If you know the starting amount, target amount, and periodic rate, PDURATION solves the missing number of periods directly.

The function is therefore well suited to horizon planning, doubling-time analysis, and target-based growth models where no recurring payments are involved.

Syntax

=PDURATION(rate, pv, fv)

rate is the interest or growth rate per period, pv is the starting value, and fv is the target value. Microsoft notes that invalid arguments return #NUM!, which is why the function should be used only with a positive rate and economically meaningful starting and ending values.

PDURATION assumes compound growth from one lump-sum starting value to one lump-sum ending value. It is not designed for models with recurring deposits or loan payments.

Arguments

• rate - Growth rate per period.
• pv - Present value, or starting amount.
• fv - Future value, or target amount.

The result uses the same period unit as the rate. If the rate is annual, the result is in years. If the rate is monthly, the result is in months. That unit should be made explicit before the output is interpreted.

PDURATION vs Other Functions

PDURATION belongs to the time-value family, but unlike some related functions it works with a simple growth path rather than a recurring payment structure.

Use PDURATION when time is the unknown in a simple compounding problem. Use NPER instead when recurring payments are part of the model.

Using the PDURATION Function

PDURATION is often used for target-timeline questions such as how long it takes to double money, reach a savings milestone, or grow a balance to a required amount at a constant rate. It is especially helpful in scenario analysis because changing the rate or target immediately changes the implied horizon.

It also works well in reporting because the result can be compared against a strategic deadline. That turns a raw period count into a simple feasibility check.

• Use PDURATION when the model has a starting value, a target value, and a constant rate.
• Keep the rate unit explicit so the result is interpreted correctly.
• Do not use PDURATION for payment-based savings or loan schedules.

Example 1 - Doubling Time (5%)

This formula returns how many years it takes for $100 to grow to $200 at a 5% annual rate. It is a direct compound-growth timing problem, so PDURATION is the right function for the job.

=PDURATION(0.05,100,200)

Example 2 - Savings Stretch (8%)

Growing $100 to $500 at 8% takes longer because the target is much farther from the starting value. This example is useful because it shows how compounding time responds to both the rate and the size of the target.

=PDURATION(0.08,100,500)

Example 3 - Maximum Term Check

This logical test compares the solved duration against a 10-year limit. It is useful when a model needs to answer not just "how long?" but also "is that time frame acceptable?"

=PDURATION(0.05,100,200)>10

Example 4 - Duration in Months

If the result is in years, multiplying by 12 converts it into months. That conversion is only valid because the underlying rate in the example is annual, so the solved period count is also annual.

=PDURATION(0.05,100,200)*12

Conclusion Recap

• Summary: PDURATION returns the number of periods required for a value to grow from one amount to another.
• Syntax: =PDURATION(rate,pv,fv).
• Core setup: Use a consistent period unit and a constant per-period growth rate.
• Best use: Doubling-time analysis, target-horizon planning, and lump-sum growth models.