Syntax

COUPDAYS(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 in the coupon, or interest payment, period that contains the specified settlement date.”

Google’s help article for COUPDAYS →

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