Excel 2000 in a Nutshell

Name

COUPDAYS

Synopsis

Use COUPDAYS (an Analysis ToolPak function) to determine the number of days within the coupon period that contains the settlement date for a security. To use this function you must know the settlement date for the security, when the security matures, and the frequency of the coupon payments.

To Calculate

=COUPDAYS(Settlement, Maturity, Frequency, Basis)

The Basis argument is the only optional argument. The others must have values.

Example

Figure 12-3 illustrates how you can use COUPDAYS to determine how many days are in the coupon period containing the settlement date.