When using COUPDAYS, the most common issues fall into 3 groups: parameter errors, unexpected results, and fill-down questions; this section answers 3 common questions.
FAQ
What should I do if COUPDAYS returns #VALUE!?
- Check whether each parameter uses the correct data type and make sure text or extra spaces are not being passed as numeric inputs.
- Confirm that referenced cells contain values that can be calculated, and clean invalid characters or spaces if needed.
- Re-enter the formula and press Enter again to see whether the error is cleared.
Why does the COUPDAYS result look different from what I expected?
- Check whether
settlement,maturity,frequency, and the optionalbasisare entered correctly. - Make sure the related cells use calculable data formats instead of plain text.
- Review the formula step by step with available formula-checking tools in the Formula tab.
How can I use COUPDAYS in multiple cells?
- Enter and confirm the COUPDAYS formula in the first cell.
- Move the pointer to the fill handle at the lower-right corner of the cell, then drag down or across.
- After filling, check whether relative and absolute references behave as expected, and use
$if you need to lock references.
Glossary
| Term | Definition |
|---|---|
| settlement | The settlement date parameter used in the coupon-period calculation. |
| maturity | The maturity date parameter for the security or instrument. |
| frequency | The coupon frequency, which indicates how many times interest is paid each year. |
| basis | An optional day-count basis parameter used to define the date calculation method. |