Excel: pduration function

Self-tutoring about Excel: the tutor mentions pduration.

To my understanding, Excel’s pduration(the_rate, amount1, amount2) function calculates the number of periods for an investment of amount1 to be worth amount2 at the_rate per period, compounded.

For instance, let’s imagine an investment of 2500 at rate 0.75% per month. How many months until it’s 7500? With Excel, one could use =pduration(0.0075, 2500, 7500) and receive the answer 147.0303 months.

Source:

support.microsoft.com