Documentation/Calc Functions/COUPDAYBS

From The Document Foundation Wiki
Jump to: navigation, search


Under construction.
For now, see the system Help files.

Function name:



Financial Analysis


Returns the number of days from the first day of interest payment on a security until the settlement date.


COUPDAYBS(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 the 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.

Basis Calculation
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

Additional details:


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 is this?

=COUPDAYBS("2001-01-25"; "2001-11-15"; 2; 3) returns 71.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: