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

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

Learn MS Excel


Ask Questions

Ask Question