Documentation/Calc Functions/DAYS360/en

Function name:
DAYS360

Category:
Date and Time

Summary:
Calculates the number of days between two dates, assuming that the year is a 360-day period composed of 12 months, each having 30 days. This type of calendar is sometimes used in business and financial contexts.

Syntax:
DAYS360(Date1; Date2[; Type])

Returns:
Returns an integer value which is the number of whole days between the two dates passed as arguments, assuming a 360-day year and calculated using the method selected through the Type argument.

Arguments:
Date1 is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is either the start date or the end date of the period for which the calculation is to be carried out.

Date2 is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is either the end date or the start date of the period for which the calculation is to be carried out.

Type is a logical value that determines the calculation method. Set Type = 0 or False to use the US/NASD method. Set Type to any other value to use the European method. If Type is omitted, the default is the US/NASD method.


 * If either Date1 or Date2 is not a valid date expression, then DAYS360 reports a #VALUE! error.
 * If Date2 is earlier than Date1, the result is a negative number; if Date2 is later than Date1, the result is a positive number.
 * DAYS360 ignores any time components of Date1 and Date2.
 * if Type is non-numeric, then DAYS360 reports a #VALUE! error.

Details specific to DAYS360 function
For more information about using a 360-day year, and the European and US/NASD methods of calculation, visit Wikipedia's 360-day calendar page. NASD is an acronym of National Association of Securities Dealers, which was a predecessor of the Financial Industry Regulatory Authority (FINRA).

For more information about the logic associated with the US/NASD and European methods as implemented in DAYS360, see the description of the function in the ODF standard.

Related LibreOffice functions:
DAYS

DATEDIF

ODF standard:
Section 6.10.7, part 2

Equivalent Excel functions:
DAYS360