COUPNUM
Financial

Returns the number of coupons payable between the settlement date and maturity date

Syntax:

=COUPNUM(settlement, maturity, frequency, [basis])

Example:

=COUPNUM("1/25/2023", "11/15/2025", 2)