Returns the number of days in the current interest period in which the settlement date falls.
COUPDAYS(Settlement; Maturity; Frequency; Basis)
Settlement is the date of purchase of the security.
Maturity is the date on which the security matures (expires).
Frequency is number of interest payments per year (1, 2 or 4).
Basis (optional) is chosen from a list of options and indicates how the year is to be calculated.
|0 or missing||US method (NASD), 12 months of 30 days each|
|1||Exact number of days in months, exact number of days in year|
|2||Exact number of days in month, year has 360 days|
|3||Exact number of days in month, year has 365 days|
|4||European method, 12 months of 30 days each|
A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there in the interest period in which the settlement date falls?
=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 3) returns 181.