Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

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.

DAYS360 Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action