YIELDDISC
Financial

Returns the annual yield for a discounted security

Syntax:

=YIELDDISC(settlement, maturity, pr, redemption, [basis])

Example:

=YIELDDISC("2/15/2023", "5/15/2023", 99.795, 100)