COUPDAYS Function
Returns the number of days in the coupon period containing settlement.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A number of days
Overview
COUPDAYS returns the length of the current coupon period in days, using the chosen basis.
The coupon functions (COUPPCD, COUPNCD, COUPNUM, COUPDAYS, COUPDAYBS, COUPDAYSNC) describe the coupon period a settlement date falls in — the building blocks of accrued interest and bond pricing.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| settlement | Yes | The date the buyer takes ownership (after the issue date). |
| maturity | Yes | The date the security is repaid. |
| frequency | Yes | Coupon payments per year: 1 = annual, 2 = semiannual, 4 = quarterly. |
| basis | No | Day count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360. |
Examples
Example 1 — Northstar's corporate bond
Northstar's treasury buys a corporate bond: 5% coupon paid twice a year, maturing 11/15/2033, settling 3/15/2026.
| A | B | |
|---|---|---|
| 1 | Settlement | 3/15/2026 |
| 2 | Maturity | 11/15/2033 |
| 3 | Frequency | 2 |
| 4 | Basis | 0 |
| 5 | Days in period | 180 |
| 6 | Days (actual, basis 1) | 181 |
On a 30/360 basis every semiannual period is 180 days; on actual days (basis 1) this one is 181.
Common mistakes
- #VALUE! or #NUM!. A date isn't a real date, settlement is on or after maturity, or frequency isn't 1, 2 or 4.
- A date result shows as a number. Format the cell as Short Date.
Notes
- Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
- Related functions: COUPPCD, COUPNCD, COUPNUM, COUPDAYS, COUPDAYBS, COUPDAYSNC.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.