## How to use the PDURATION function

*Article last updated on July 31, 2018*

The PDURATION function calculates how many periods required by an investment to reach a given amount based on a percentage rate.

Formula in cell C7:

### Excel Function Syntax

PDURATION(*Rate, Pv, Fv*)

### Arguments

Rate |
Required. Rate is the interest rate per period. |

Pv |
Required. Pv is the present amount of the investment. |

Fv |
Required. Fv is the desired future amount of the investment. |

### Comments

The PDURATION function returns

- #VALUE error if invalid data types are used.
- #NUM error if argument values are invalid.

Positive values are required as arguments.

### Equivalent formula

The following formula calculates the exact same thing as the PDURATION function.

Formula in cell C5:

This formula explains in depth how the PDURATION function works.

*Fv*)-LOG(

*Pv*))/LOG(1+

*Rate*)

### Functions in 'Financial'

The PDURATION function function is one of many functions in the 'Financial' category.

How to use the ACCRINT function

The ACCRINT function calculates the accrued interest for a security that pays periodic interest. Formula in cell C9: =ACCRINT(C2,C3,C4,C5,C6,C7,C8) Excel […]

How to use the ACCRINTM function

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. Formula in cell C7: =ACCRINTM(C2,C3,C4,C5,C6) […]

How to use the EFFECT function

The EFFECT function calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding […]

The FV function returns the future value of an investment based on a constant interest rate. You can use FV […]

The ISPMT calculates the interest paid during a specific period of an investment. Formula in cell B3: =ISPMT(0.1/12,1,4*12,10000) Excel Function […]

How to use the NOMINAL function

The NOMINAL function calculates the nominal annual interest rate based on the effective rate and the number of compounding periods […]

How to use the PDURATION function

The PDURATION function calculates how many periods required by an investment to reach a given amount based on a percentage […]

The RATE function returns the interest rate per period of an annuity. Formula in cell E3: =RATE(B3,C3,D3) Excel Function Syntax […]

## How to comment

How to add a formula to your comment<code>Insert your formula here.</code>

Convert less than and larger than signsUse html character entities instead of less than and larger than signs.

< becomes < and > becomes >

How to add VBA code to your comment[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

How to add a picture to your comment:Upload picture to postimage.org or imgur

Use the img tag, like this: <img src="Insert pic link here">

Contact OscarYou can contact me through this contact form