DAYS360 Function

Basic Description

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

Syntax: 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

 

Note that the start_date and end_date arguments should be input as either references to cells containing dates or dates returned from formulas. 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.

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

 

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:
A B
1 01-Jan-2015 =DAYS360( A1, A2 )
2 31-Jan-2015 =DAYS360( A1, A2, TRUE )
3 01-Feb-2015 =DAYS360( A1, A3, FALSE )
4 =DAYS360( A3, DATE( 2015, 2, 2 ) )
 Results:
A B
1 01-Jan-2015 30
2 31-Jan-2015 29
3 01-Feb-2015 30
4 1

In the above example :

  • In cells B1 and B4 the [method] argument has been omitted. Therefore, the US (NASD) method is used.
  • In cells B2, the [method] argument is set to TRUE, so the European method is used. Note that this gives a different result from the function in cell B1, which uses the same two dates with the US (NASD) method.

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 cell B4, the Date function is used to supply the end_date argument).

 

DAYS360 Function Errors

#NUM! – Occurs if one or both of the supplied arguments are numeric values, but are not recognised as valid dates.
#VALUE! – Occurs if one or both of the supplied arguments are text values that can not be interpreted as dates.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment