deepcalc
DocsCOUPDAYBS

COUPDAYBS

View as markdown/docs/functions/coupdaybs.md Ask Claude about this pageOpens Claude with this page's address

Days from coupon period start to settlement.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=COUPDAYBS(DATE(2026,1,15), DATE(2030,1,15), 2)
Result 0

Syntax

COUPDAYBS(settlement, maturity, frequency, [basis])
settlement
number required
maturity
number required
frequency
number required
basis
number optional

Errors

#NUM!
=COUPDAYBS(2, 2, 2)
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYSDays in the coupon period containing settlement. COUPDAYSNCDays from settlement to the next coupon date.