DURATION
Financial

Returns the annual duration of a security with periodic interest payments

Syntax:

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

Example:

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