COUPPCD
Financial

Returns the previous coupon date before the settlement date

Syntax:

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

Example:

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