WorksheetFunction.PDuration method (Excel)

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


expression. PDuration(Arg1, Arg2, Arg3)

expression A variable that represents a WorksheetFunction object (Excel) object.


Name Required/Optional Data type Description
Arg1 Required DOUBLE Interest rate per period.
Arg2 Required DOUBLE Present value of the investment.
Arg3 Required DOUBLE Desired future value of the investment.

Return value


See also

WorksheetFunction Object