The Excel DURATION function returns the Macaulay duration of a bond — the weighted-average time to receive its cash flows, a key interest-rate-risk measure. Settlement and maturity are dates wrap them in DATE() so Excel reads them correctly..
Syntax
| Argument | Description | |
|---|---|---|
settlement | Required | Settlement date. |
maturity | Required | Maturity date. |
coupon | Required | Annual coupon rate. |
yld | Required | Annual yield. |
frequency | Required | Coupons per year. |
basis | Optional | Day-count basis. |
How to use it
DURATION returns the Macaulay duration of a bond — the weighted-average time to receive its cash flows, a key interest-rate-risk measure. Settlement and maturity are dates wrap them in DATE() so Excel reads them correctly..
Try it: interactive demo
This is the formula pattern DURATION uses — copy it into Excel with your own numbers.
Practice workbook
Frequently asked questions
How do I enter the dates?
Which Excel versions support it?
Why might it return #NUM! or #VALUE!?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class