Excel Functions

# Excel DURATION Function

The Excel DURATION Functions help calculate the Macauley Duration. The function calculates the duration of a security that pays interest on a periodic basis with a par value of \$100. In MS-Excel the DURATION function is categorized under financial function. The Macauley duration is the weighted average term to maturity of the cash flows from a bond.

## Purpose of Excel DURATION Function

To get Macauley duration for an assumed par value of \$100.

## Return value

DURATION function returns the Macauley duration in years.

## Syntax

= DURATION(settlement, maturity, coupon, yld, frequency, [basis])

## Usage note

• The parameters such as settlement, maturity, frequency, basis are truncated to integers.
• If settlement or maturity is not a valid date, DURATION returns the #VALUE! error value.
• If coupon < 0 or if yld < 0, DURATION returns the #NUM! error value.
• If frequency is any number other than 1, 2, or 4, DURATION returns the #NUM! error value
• If basis < 0 or if basis > 4, DURATION returns the #NUM! error value.
• If settlement ≥ maturity, DURATION returns the #NUM! error value.
• Microsoft Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 1, 2018 is serial number 43101 because it is 43,101 days after January 1, 1900.

### Availability

Since 2007 for Windows.
Since 2011 for Mac.

#### Related Posts

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…

More off this less hello salamander lied porpoise much over tightly circa horse taped so innocuously outside crud mightily…