Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42 DAYS360 Function / Formula in Microsoft Excel 2007 | Video Tutorial
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.
=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.
Let us find the number of days between two given dates, using DAYS360 function, with the help of the below video