Quick Answer

COUPDAYSNC Function

Calculates the number of days from the settlement date to the next coupon date.

Syntax

COUPDAYSNC

(settlement, maturity, frequency, [basis])

Parameters

Parameter	Description	Required
settlement	Date the security is purchased.	Required
maturity	Date the security expires.	Required
frequency	Number of coupon payments per year (1, 2, or 4).	Required
basis	Day-count convention (0 = US 30/360, default).	Optional

Basic Example

Days until next coupon payment

=COUPDAYSNC(DATE(2024,4,1), DATE(2034,4,1), 2)

ResultDays to next coupon

For a semi-annual bond purchased on April 1, 2024, this returns the days until the next coupon payment.

Advanced Examples

Example 1: Actual days to next coupon

Treasury bond

Use basis 1 for actual days

=COUPDAYSNC(DATE(2024,4,1), DATE(2034,4,1), 2, 1)

Result: Actual days to next coupon

Basis 1 counts actual days.

How COUPDAYSNC Works

COUPDAYSNC is used to determine how many days remain until the next coupon payment, which affects the clean vs. dirty price of a bond.

1

Enter settlement

Type the settlement

2

Enter maturity

Type the maturity

3

Enter frequency

Type the frequency

4

Enter basis

Type the basis

5

Calculate

Press Enter to get the result.

Important Notes & Limitations

Frequency must be 1, 2, or 4.
Basis affects the day count.
Settlement must be before maturity.

Common Errors & Fixes

#NUM! errorInvalid dates, frequency, or basis.

Fix: Verify all inputs.

#VALUE! errorDates are not recognized.

Fix: Use DATE function or valid date serial numbers.

Download Practice File

Practice COUPDAYSNC with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the COUPDAYSNC function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Related Functions

ACCRINT

Calculates accrued interest for a security that pays periodic interest.

ACCRINTM

Calculates accrued interest for a security that pays interest at maturity.

AMORDEGRC

Calculates depreciation for a specific period using the French declining balance method.

AMORLINC

Calculates depreciation for a specific period using the French straight-line method.

COUPDAYBS

Calculates the number of days from the beginning of the coupon period to the settlement date.

COUPDAYS

Calculates the number of days in the coupon period that contains the settlement date.

Frequently Asked Questions

What is the difference between COUPDAYSNC and COUPDAYBS?

COUPDAYSNC counts days from settlement to the next coupon. COUPDAYBS counts days from the coupon start to settlement.

How is COUPDAYSNC used in bond pricing?

It helps determine the accrued interest and the dirty price of a bond.