Returns the difference between two days based on the 360-day year used in some financial interest calculations.
Sample usage
DAYS360(DATE(1969,7,16),DATE(1969,7,24),1)
DAYS360(A2,A3)
DAYS360(1,270,1)
Syntax
DAYS360(start_date, end_date, [method])
-
start_date
– The start date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type or a number. -
end_date
– The end date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type or a number. -
method
– [ OPTIONAL –0
by default ] – An indicator of which day count method to use.- 0 indicates the US method – under the US method, if the
start_date
is the last day of a month, the day of month of thestart_date
is changed to 30 for the purposes of the calculation. Furthermore, if theend_date
is the 31st day of a month and the day of the month of thestart_date
is earlier than the 30th, theend_date
is changed to the first day of the month following theend_date
. Otherwise, the day of month of theend_date
is changed to 30. -
Any other value indicates the European method – under the European method, any
start_date
orend_date
that falls on the 31st of a month has its day of the month changed to30
.
- 0 indicates the US method – under the US method, if the
Notes
-
This function is mostly used in a financial setting, for calculations involving fixed-income securities. Other usage is likely incorrect.
-
Ensure that the inputs to the function are either references to cells containing dates, functions that return date objects, such as
DATE
,DATEVALUE
orTO_DATE
, or date serial numbers of the type returned by theN
function. Google Sheets represents dates and times as numbers. Whilst conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format. -
DAYS360
does not auto-convert number formats in the same way as Google Sheets does upon direct entry into cells. Therefore,DAYS360(10/10/2000,10/10/2001)
is interpreted asDAYS360(0.005,0.00499750124938)
, the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.
See also
YEARFRAC
: Returns the number of years, including fractional years, between two dates using a specified day count convention.
TO_DATE
: Converts a provided number into a date.
N
: Returns the argument provided as a number.
DATEVALUE
: Converts a provided date string in a known format into a date value.
DATE
: Converts a year, month and day into a date.
Examples
Returns the difference between two dates using a different method.