DAYS360 Function

The DAYS360 function is one of the date and time functions. Is used to return the number of days between two dates (start-date and end-date) based on a 360-day year using one of the calculation method (US or European).

Syntax

DAYS360(start_date, end_date, [method])

The DAYS360 function has the following arguments:

Argument	Description
start_date	start_date and end_date are two dates you wish to calculate the number of days between.
end_date	start_date and end_date are two dates you wish to calculate the number of days between.
method	An optional logical value: TRUE or FALSE. If it is set to TRUE, the calculation will be performed using the European method, according to which the start and end dates that occur on the 31st of a month become equal to the 30th of the same month. If it is FALSE or omitted, the calculation will be performed using the US method, according to which if the start date is the last day of a month, it becomes equal to the 30th of the same month. If the end date is the last day of a month and the start date is earlier than the 30th of a month, the end date becomes equal to the 1st of the next month. Otherwise the end date becomes equal to the 30th of the same month.

Notes

How to apply the DAYS360 function.

Examples

The figure below displays the result returned by the DAYS360 function.

Return to previous page