Syntax

COUPNUM(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 coupons, or interest payments, between the settlement date and the maturity date of the investment.”

Google’s help article for COUPNUM →

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