Excel Function : PDURATION
Category
Financial
Description
Returns the number of periods required by an investment to reach a specified value
Microsoft Excel Reference Page
https://support.office.com/en-us/article/PDURATION-function-44f33460-5be5-4c90-b857-22308892adaf
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.
