WorksheetFunction.PDuration Method (Excel)

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

Syntax

expression. PDuration(Arg1, Arg2, Arg3)

expression A variable that represents aWorksheetFunction Object (Excel) object.

Parameters

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

DOUBLE

See also

WorksheetFunction Object