Excel Function : COUPPCD
Returns the previous coupon date before the settlement date
Microsoft Excel Reference Page
Syntax and Description of the COUPPCD Excel Function
. The syntax of the CoupPCD function is: CoupPCD(settlement, maturity, frequency, [basis]) The CoupPCD function syntax has the following arguments: Settlement Required. The security's settlement date. The settlement date is the date after the issue date when the security is traded to the buyer. Maturity Required. The security's maturity date. The maturity date is the date when the security expires. Frequency Required. The number of coupon payments per year. Basis Optional. The type of day count basis to use. Here is a look at the formula I used in the spreadsheet above: Here is a look at the syntax of the COUPDAYBS function:
About COUPPCD Excel Function
COUPPCD returns the number of days from the beginning of the coupon period to the settlement date.