I. Intro
The COUPDAYSNC function returns the number of days from the settlement date to the next coupon or interest payment date.
II. About the function
- Formula: =COUPDAYSNC(settlement, maturity, frequency, [basis])
- Parameters:
- Settlement (required): The settlement date of the security (the date after the issue date when the buyer takes ownership of the security).
- Maturity (required): The maturity date or end date of the security (the date when the security can be redeemed at face or par value).
- Frequency (required): The number of coupon payments per year (1, 2, or 4).
- Basis (optional): The calculation method to be used, as explained below.
0 or empty | US (NASD) 30/360 |
1 | Actual/Actual |
2 | Actual/360 |
3 | Actual/365 |
4 | European 30/360 |
- Example:
- =COUPDAYSNC("2021-1-1", "2021-12-31", 4, 0)
- Calculates the number of days between interest payments with 4 interest payments per year from January 1, 2021, to December 31, 2021.
- Note:
- Use double quotation marks (") around the settlement date and maturity date in the formula.
III. Steps
- Select a cell and click Formulas in the toolbar, select All functions, and search for COUPDAYSNC. You can also directly enter =COUPDAYSNC in a cell.
- Enter the parameters (settlement, maturity, frequency, [basis]). The basis parameter is optional.
- Press Enter to display the result.
- 250px|700px|reset