Syntax

COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])

Arguments

The printed syntax lists 4 argument(s), in order:

  • settlement
  • maturity
  • frequency
  • ay_count_conventio optional

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

“Calculates the number of days from the settlement date until the next coupon, or interest payment.”

Google’s help article for COUPDAYSNC →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 83 of 516, data fetched 28 September 2026. Data month: September 2026.