Excel Function : PDURATION

Download now!

Excel Function : PDURATION




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

Microsoft Excel Reference Page


Syntax and Description of the PDURATION Excel Function

The syntax for the PDURATION function in Microsoft Excel is: PDURATION( rate, present_value, future_value [, basis] ) rate - The interest rate per period. present_value - The present value of the investment. future_value - The future value of the investment. basis - [optional] The type of day count basis to use.

About PDURATION Excel Function

The PDURATION function calculates the number of days, months, or years between two dates. The syntax for the PDURATION function is: PDURATION(start_date, end_date, [basis]) Where: start_date - The start date. end_date - The end date. basis - The type of day count basis to use: 0 (or omitted) for US (NASD) 30/360, 1 for Actual/actual, 2 for Actual/360, or 3 for Actual/365.