COUPDAYSNC Function in Google Sheets

Calculate the number of days from the settlement date to the next coupon date using the COUPDAYSNC function.

COUPDAYSNC Function

The COUPDAYSNC function in Google Sheets calculates the number of days from the settlement date to the next coupon date.

Syntax

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
  • settlement: The security’s settlement date.
  • maturity: The security’s maturity date.
  • frequency: The number of coupon payments per year (1, 2, or 4).
  • day_count_convention: (Optional) The day count convention to use. Default is 0 (actual/actual).

Examples

  1. Days to Next Coupon Calculation

Calculate the days from settlement to the next coupon date:

=COUPDAYSNC("1/1/2023", "1/1/2028", 2)

This will output the number of days until the next coupon date.

  1. Using a 30/360 Basis

Calculate using a 30/360 basis:

=COUPDAYSNC("1/1/2023", "1/1/2028", 2, 1)

This will output the number of days based on the 30/360 basis.

Notes

  • This function is crucial for bond investors to determine when the next coupon payment will occur.
  • Ensure the

settlement date is before the maturity date to avoid errors.

  • COUPNCD: Calculate the next coupon date after the settlement date.
  • COUPDAYS: Calculate the number of days in the coupon period containing the settlement date.