deepcalc
DocsCOUPDAYS

COUPDAYS

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

Days in the coupon period containing settlement.

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

Examples

=COUPDAYS(DATE(2026,1,15), DATE(2030,1,15), 2)
Result 180

Syntax

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

Errors

#NUM!
=COUPDAYS(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. COUPDAYBSDays from coupon period start to settlement. COUPDAYSNCDays from settlement to the next coupon date.