PDURATION Function

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.

This is a useful beginner example because the doubling idea is easy to picture. It helps the learner focus on what PDURATION solves: the missing time, not the missing rate or payment.

=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.

So the example teaches more than one answer. It shows that a bigger target can stretch the timeline a lot, even when the annual growth rate stays attractive.

=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?"

That makes the formula practical for planning sheets. The workbook can move from a raw duration result into a direct yes-or-no decision about whether the goal is fast enough.

=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.

This is helpful when a monthly timeline is easier to communicate. The example also reminds the learner that unit conversion only works if the original rate and result use matching time units.

=PDURATION(0.05,100,200)*12

Conclusion Recap

PDURATION is useful when you already know the starting amount, the target amount, and the growth rate, but you do not know how long the journey will take. In this lesson, that showed up in doubling-time questions, bigger growth targets, limit checks, and converting the answer from years into months.

The easiest way to remember this function is that it solves a lump-sum growth timeline, not a payment schedule. If money is just compounding from one value to another, PDURATION fits well. If recurring contributions are involved, a different function is usually the better choice.

• 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.