COUPDAYBS function
Returns the number of days from the beginning of the coupon period to the settlement date
Syntax
COUPDAYBS(settlement, maturity, frequency, [basis])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| settlement | Yes | The security's settlement date."2011-1-25" |
| maturity | Yes | The security's maturity date."2011-11-15" |
| frequency | Yes | The number of coupon payments per year.2 |
| basis | No | The type of day count basis to use.1 |
Try COUPDAYBS
Count accrued days in the current coupon period
=COUPDAYBS(A2,B2,C2,D2)The previous coupon is December 15, 2025. US 30/360 counts four 30-day months to April 15, 2026, giving 120 days. The numeric date inputs are Excel serial dates; format a date result as a date to read it. Frequency is payments per year, not months per payment. Basis 0 is US 30/360; actual/actual and other bases can give different day counts. These are synthetic teaching terms.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
COUPDAYBS · top-level call
=COUPDAYBS(A2,B2,C2,D2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.