DISC
Financial

Returns the discount rate for a security

Syntax:

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

Example:

=DISC("1/25/2023", "6/15/2023", 97.975, 100)