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