Documentation/Calc Functions/COUPDAYSNC

Function name:
COUPDAYSNC

Category:
Financial Analysis

Summary:
Calculates the number of days between the settlement date and the next coupon date.

Syntax:
COUPDAYSNC(Settlement; Maturity; Frequency[; Basis])

Returns:
Returns a positive integer which is the count of days from the settlement date until the next coupon date.

Arguments:
Settlement is a date or a reference to a cell containing that date which is the settlement date.

Maturity is a date or a reference to a cell containing that date which is the maturity date.

Frequency is a positive integer or a reference to a cell containing that integer which is the number of interest payments per year (1, 2 or 4).


 * If either of Settlement or Maturity is not a valid date then the function returns a value (#VALUE!) error. However, dates are essentially just numbers (search for "date and time functions" in the Help for more information).
 * If the Settlement date is on or after the Maturity date then the function reports an invalid argument error (Err:502).
 * If either Frequency or Basis is a non-integer value, then the function uses its floor value, i.e. it is truncated to an integer value.
 * After truncation if Frequency is any number except 1,2 or 4, then the function reports an invalid argument error (Err:502).
 * After truncation if Basis is ny number except 0,1,2,3,4 or missing, then the function reports an invalid argument error (Err:502).

Additional details:
If Basis is 1, 2, or 3 (when the actual number of days per month is used for counting days) then the function uses [[Special:MyLanguage/Documentation/Calc_Functions/COUPNCD COUPNCD] to find the next coupon date after the settlement date, and then calculates the number of days between the settlement date and that coupon date.

If Basis is 0 or 4 (when 30 days are assumed per month) then the function calculates the number of days in the coupon period that contains the settlement date using [[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYS COUPDAYS], and subtracts the number of days from the first day of interest payment on the security until the settlement date (calculated using [[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYBS COUPDAYBS]).

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYS COUPDAYS]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPDAYBS COUPDAYBS]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPNCD COUPNCD]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPNUM COUPNUM]

[[Special:MyLanguage/Documentation/Calc_Functions/COUPPCD COUPPCD]

ODF standard:
Section 6.12.7, part 2

Equivalent Excel functions:
COUPDAYSNC