How to Use the PDURATION Function in Google Sheets

Published on

This article describes the use of the PDURATION, which is a financial function, in Google Sheets.

What is the purpose of the function PDURATION?

Use PDURATION to calculate the number of periods required for an investment to reach a specified (desired) value at a given (interest) rate.

This given rate is important. Do you know why?

If you know the present value of an investment, the desired value aka future value and the number of periods, then to find the interest rate, there is a different function. Use the RRI function in such a scenario.

Here we have the present value (pv), desired value/future value (fv) and the rate (interest rate). We want to find the duration.

PDRUATION – Syntax and Arguments

PDURATION(rate, present_value, future_value)

rate – interest rate.

present_value (pv) – the present value of the investment.

future_value (fv) – the future value of the investment.

PDURATION Function and Alternative Formula in Google Sheets

Example 1:

Find the number of years required for an investment to the tune of $10,000.00 to reach $15,000.00 at an annual interest rate of 6%.

The duration we can find as below.

=PDURATION(B1,B2,B3)
Examples to the Use of PDURATION Function in Google Sheets

Example 2:

Find the number of months required for an investment to the tune of $2,000.00 to reach $3,500.00 at an annual interest rate of 8%.

I am skipping the screenshot here and providing you the input values as a table. I hope this can help you to copy it.

AB
1Rate8%
2PV2000
3FV3500
4PDURATION?

Here the interest rate, i.e. 8%, is the annual interest rate. We want the duration in the number of months.

So first convert the annual rate to a monthly rate. How?

To convert the annual rate to the monthly rate, divide B2 (annual rate) by 12.

Formula:

=PDURATION(B1/12,B2,B3)

Result: 84.22 months.

Alternative to PDURATION in Google Sheets (Additional Info.)

You can use another formula to find the duration of investment to reach a desired/specific value in Google Sheets. Here is that formula.

Here also we can use just above sample data.

For calculating the duration in years;

=(log(B3)-log(B2))/log(1+B1)

For duration in months;

=(log(B3)-log(B2))/log(1+B1/12)

Common Errors

PDURATIION normally returns two types of errors. They are #NUM! and #VALUE!. Here are the possible reasons.

#NUM! – If rate/pv/fv is not specified or set to 0 or less than 0, the formula will return this error.

#VALUE! – In case of invalid data types as input like strings.

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Expert Prashanth KV is a Diamond Product Expert in Google Sheets, officially recognized by Google for his contributions to the Docs Editors Help Community and featured in the Google Product Experts Directory. With years of experience working with Google Sheets and Excel for multinational firms in Mumbai and Dubai, he has been blogging since 2012, offering practical, real-world spreadsheet solutions that professionals rely on. Explore his blog to learn advanced formulas, automation tips, and problem-solving techniques to elevate your spreadsheet skills.

Mode of Comma-Separated Numbers in Excel (Dynamic Array)

There is no dedicated function in Excel to directly find the mode of comma-separated...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

Count Consecutive Workday Absences in Google Sheets

This tutorial offers a powerful formula-based solution to count consecutive workday absences in Google...

More like this

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

Count Consecutive Workday Absences in Google Sheets

This tutorial offers a powerful formula-based solution to count consecutive workday absences in Google...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.