Financial Excel 2013 ◉ 11 views

=PDURATION()

Returns the number of periods required by an investment to reach a specified value.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016

=PDURATION(rate, pv, fv)

Hover argument names in the table for details.

Output typeNumber

Popularity15 / 100

VolatileNo

Dynamic ArrayNo

📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =PDURATION() with Persian sample data & live formulas — open in Excel and practice.

Sheet “Sample” — data table + formula in place
Sheet “Guide” — syntax, arguments & tips from this page
Instant & secure (token + rate limit)

📥 Download PDURATION.xlsx — Coming soon ~ 8–12 KB · No macros

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

Start quiz →

◧ Arguments

Argument	Type	Required	Description
`rate`	Number	Required	Rate is the interest rate per period.
`pv`	Number	Required	Pv is the present value of the investment.
`fv`	Number	Required	Fv is the desired future value of the investment.

▣ Examples

The number of years required for an investment of $2,000, earning 2.5% annually, to reach $2,200 (3.86 years). =PDURATION(2.5%,2000,2200)

Result: 3.86

The number of months required for an investment of $1,000, earning 2.5% annually, to reach $1,200 (87.6 months). =PDURATION(0.025/12,1000,1200)

Result: 87.6

§ Remarks

PDURATION requires that all arguments are positive values.
If argument values are not valid, PDURATION returns the #NUM! error value.
If arguments are not using valid data types, PDURATION returns the #VALUE! error value.

✦ Tips

PDURATION requires that all arguments are positive values.

⚠ Common Errors

#NUM! If argument values are not valid, PDURATION returns the #NUM! error value.

Fix: Enter positive numbers

#VALUE! If arguments are not using valid data types, PDURATION returns the #VALUE! error value.

Fix: بررسی کنید همه آرگومان‌ها عددی باشند؛ متن یا سلول خالی را اصلاح کنید.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!