DAYS360
Description
Returns an integer representing the number of days between two specified dates, based on a
360-day year.
Syntax
DAYS360(
start_date
,
end_date
, [
method
])
- start_date: The starting date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
- end_date: The ending date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
- method: The method to use in the count. False or omitted = US (NASD) method; True = European method.
- In the US method, ifstart_dateis last day of a month, Workday sets it to the 30th of that month. Ifend_dateis last day of month, then ifstart_dateis the last day of month, Workday setsend_dateto the 1st of the following month; otherwise, Workday setsend_dateto the 30th of that month.
- In the European method, ifstart_dateis the last day of the month, Workday sets it to the 30th of that month. Ifend_dateis the last day of the month, Workday sets it to the 30th of that month.
Example
Formula | Result |
|---|---|
=DAYS360("01-Jan-2016", "1-Jan-2017") | 360 |
=DAYS360("01-Dec-2016","14-Jul-2016") | -137 |