Skip to content
Excel

COUPDAYBS function in Excel

Returns the number of days from the beginning of the coupon period to the settlement date

=COUPDAYBS(settlement, maturity, frequency, [basis])

COUPDAYBS syntax and parameters

Four arguments, three required.

  • settlementanyRequired

    The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.

  • maturityanyRequired

    The security's maturity date. The maturity date is the date when the security expires.

  • frequencynumberRequired

    The number of coupon payments per year. For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

  • basisanyOptional

    The type of day count basis to use.

COUPDAYBS examples

Formulas you'll actually reuse.

  1. Days from the previous coupon to settlement, 30/360:

    =COUPDAYBS(DATE(2026, 5, 15), DATE(2031, 3, 15), 2, 0)

    Result60

  2. Accrued interest by hand — the accrued fraction of one $25 coupon:

    =1000 * 5% / 2 * COUPDAYBS(B2, C2, 2, 0) / COUPDAYS(B2, C2, 2, 0)

    Result8.3333

COUPDAYBS in Google Sheets

Same name — your formula ports as-is.

Try COUPDAYBS in the playground

Edit the example — nothing to install.

Preloaded with the COUPDAYBS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.