DAYS360
Formula Explanation
The DAYS360 function calculates the number of days between two dates using the 360-day year algorithm (30 days per month, 12 months per year). This is commonly used in some accounting calculations.
It can be useful for calculating payment periods in accounting systems that use a 360-day year with 12 months of 30 days each.
Formula Syntax
Enter in the result column: DAYS360(date / column number, date / column number, [method]);
The DAYS360 function syntax has the following arguments:
Date or column number (required): The start and end dates for which you want to calculate the period in days. If start_date is after end_date, the DAYS360 function returns a negative number. You should use the DATE function to input dates or input dates derived from other formulas or functions. For example, use the DATE function like DATE(2008,5,23) to return May 23, 2008. Inputting dates as text may cause issues.
Method (optional): A logical value that specifies whether to use the U.S. method or European method in the calculation.
FALSE or omitted: U.S. (NASD) method. If the start_date is the last day of a month, it is treated as 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, the end_date is treated as the 1st of the next month; otherwise, it is treated as the 30th of the same month.
TRUE: European method. If both the start_date and end_date are the 31st of a month, they are both treated as the 30th of the same month.
Usage Example
- Calculate the number of days between the dates in columns CO2 and CO3 using the 360-day year algorithm. Write the results into column CO4.
CO4 = DAYS360(CO2, CO3)
