The Excel DAYS360 Function

Related Function:
NETWORKDAYS

Basic Description

The Excel Days360 function returns the number of days between 2 dates, based on a 360-day year (12 x 30 months).

The format of the function is :

DAYS360( start_date, end_date, [method] )

where the arguments are as follows:

start_date - The start of the period
end_date - The end of the period
[method] - An optional logical argument, which gives the method to be used in the calculation. This can be either:
FALSE (or omitted) - US (NASD) method used
or
TRUE - European method used

US vs. European Method

US Method:

  • If start date is last day of month it is set to 30th of that month
  • If end date is last day of month, then:
  • If start date is last day of month the end date is set to the 1st of the following month
  • Otherwise, the end date is set to 30th of that month

European Method:

  • If start date is last day of month it is set to 30th of that month
  • If end date is last day of month, then it is set to 30th of that month
The financial day count basis rules are explained in more detail on the Wikipedia Day Count Convention page

Note that the start_date and end_date arguments should be input as either:

or

- If you attempt to input the start_date and end_date as text, there is a chance that Excel may misinterpret this due to different date systems, or date interpretation settings.

Warning: Although you can input the dates as serial numbers, this is not recommended as the serial numbers may vary across different computer systems.


Excel Days360 Function Examples

The spreadsheets below show simple examples of the Excel Days360 function. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.

 Formulas:
Examples of use of the Excel Days360 Function
 Results:
Excel Days360 Function Results

In the above example :

Note also that, as recommended by Microsoft, in all four calls to the Days360 function, the start_date and end_date arguments have been supplied as either cell references or the return values from functions (in the example the Excel Date function is used to supply the end_date argument to the function in cell B4).

Return to the Excel Date and Time Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net