Excel Function : DURATION
Returns the annual duration of a security with periodic interest payments
Microsoft Excel Reference Page
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.