Returns the difference between two days based on the 360-day year used in some financial interest calculations.
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 -
0by default ] - An indicator of what day count method to use.
0 indicates the US method - Under the US method, if
start_dateis the last day of a month, the day of month of
start_dateis changed to
30for the purposes of the calculation. Furthermore if
end_dateis the last day of a month and the day of the month of
start_dateis earlier than the 30th,
end_dateis changed to the first day of the month following
end_date, otherwise the day of month of
end_dateis changed to
Any other value indicates the European method - Under the European method, any
end_datethat falls on the 31st of a month has its day of month changed to
This function is mostly used in a financial setting, for calculation involving fixed-income securities. Other usage is likely incorrect.
Ensure that the inputs to the function are either references to cells containing dates, functions which return date objects such as
TO_DATE, or date serial numbers of the type returned by the
Nfunction. Google Sheets represents dates and times as numbers; while conversion is automatic when a human-readable date is entered into a cell, functions only accept literal dates in numeric format.
DAYS360does not auto-convert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,
DAYS360(10/10/2000,10/10/2001)is interpreted as
DAYS360(0.005,0.00499750124938), the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.
YEARFRAC: Returns the number of years, including fractional years, between two dates using a specified day count convention.
TO_DATE: Converts a provided number to a date.
N: Returns the argument provided as a number.
DATEVALUE: Converts a provided date string in a known format to a date value.
DATE: Converts a year, month, and day into a date.
Returns the difference between two dates using different method.