## Calculating EXCEL Duration Between Bond Coupon Payments

Excel duration between coupon dates How does EXCEL calculate DURATION for settlement dates between coupon dates? This was a question posed by one of our readers recently. We have already examined the calculation of Excel Duration and Price functions when settlement dates equal coupon payments dates in