Excel Function : DURATION

Download now!

Excel Function : DURATION

Category

Financial

Description

Returns the annual duration of a security with periodic interest payments

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DURATION-function-b254ea57-eadc-4602-a86a-c8e369334038

Syntax and Description of the DURATION Excel Function

? The syntax for the DURATION function in Excel is: DURATION(settlement, maturity, frequency, [basis]) The settlement and maturity arguments are the dates of the start and end of the investment period. The frequency argument is the number of coupon payments per year. The basis argument is optional and is the type of day count basis to use.

About DURATION Excel Function

The DURATION function calculates the number of days, months, or years between two dates. The syntax for the DURATION function is: =DURATION(start_date, end_date, [unit]) The start_date and end_date arguments are the start and end dates that you want to use in the calculation. The unit argument is optional and specifies the units that you want to use in the calculation. If the unit argument is omitted, the DURATION function will return the number of days between the two dates.