COUPDAYSNC
Financial

Returns the number of days from the settlement date to the next coupon date

Syntax:

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

Example:

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