DAYS360 Function
The DAYS360 function is used to calculate the number of days between 2 given dates in a 360 days/year in which each month has 30 days.
Note: The function does not consider the last day while calculating.
Formula:
=DAYS360(Start Date, End Date, Method)
Whereas "Method" should be either "True" or "False". True uses European accounting systems to return the answer and False uses USA accounting systems.
TRUE - Starting dates and ending dates that occur on the 31st of a month become equal to the 30th of the same month.
FALSE - If the starting date is the last day of a month, it becomes the 30th of the same month.If the ending date is the last day of a month and the starting date is earlier than the 30th of a month, the ending date becomes the 1st of the next month; otherwise the ending date becomes the 30th of the same month.
Video Tutorial:
Let us find the number of days between two given dates, using DAYS360 function, with the help of the below video
