MDURATION
Financial

Returns the modified Macauley duration for a security with an assumed par value of $100

Syntax:

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

Example:

=MDURATION("1/1/2023", "1/1/2025", 0.08, 0.09, 2)