Syntax

COUPDAYBS(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 first coupon, or interest payment, until settlement.”

Google’s help article for COUPDAYBS →

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