=COUPPCD(settlement, frequency, maturity, [basis])
=COUPPCD(C6,C7,C10,C11) returns 1-Jul-2019. This Sourcetable function calculates the next coupon payment date, given the start and end dates of the bond, and the coupon frequency and basis.
=COUPPCD(DATE(2019,9,1),DATE(2029,1,1),2,0) returns 1-Jul-2019 with hardcoded values. Here, the start and end dates are hardcoded as September 1, 2019, and January 1, 2029, respectively. The coupon frequency is 2 and the basis is 0.
The COUPPCD function can be used to quickly determine the previous coupon date before a given settlement date. It is an efficient tool for financial calculations.