MS Excel: Days360 Function
In Excel, the Days360 function returns the number of days between two dates based on a 360-day year.
The syntax for the Days360 function is:
Days360( start_date, end_date, method )
start_date and end_date are the two dates to calculate the difference between.
method is a boolean value - either TRUE or FALSE. If TRUE is entered, the Days360 function will use the US method. If FALSE is entered, the Days360 function will use the European method.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the spreadsheet above, the function would return the following values:
=Days360(A1, A2, TRUE) would return 361 =Days360(A2, A3, TRUE) would return 88 =Days360("30-Nov-2003", "1-Dec-2003") would return 1