Related Functions:

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

Syntax

=DAYS360(start_date,end_date,[method])

Arguments

Argument Description
start_date The start of the period
end_date The end of the period
[method]  
FALSE (or omitted) US (NASD) method used

  When the start_date is the last day of the month, it is set to the 30th day of the same month
  When the end_date is the last day of the month, and the start_date < 30, the end_date is set to the 1st of the next month, otherwise the end_date is set to the 30th of the same month
TRUE European method used

  The start_date and end_date equal to the 31st of a month are set to the 30th of the same month

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

  • References to cells containing dates, or
  • Dates returned from formulas

Warning: 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.

Examples

  A B C D E
1 Start date End date Formula Result Notes
2 01-Jan-2013 31-Dec-2013 =DAYS360(A2,B2) 360 12 months * 30 days per month
3 01-Feb-2013 01-Mar-2013 =DAYS360(A3,B3) 30 February calculates to 30 days
4 01-Jun-2013 01-Nov-2013 =DAYS360(A4,B4) 150 5 months * 30 days per month
5 10-Sep-2013 10-Dec-2013 =DAYS360(A5,B5) 90 3 months * 30 days per month
6 31-Jan-2013 1-Feb-2013 =DAYS360(A6,B6) 1 Start date set to January 30

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if one or both of the supplied arguments are numeric values, but are not recognized as valid dates
#VALUE! Occurs if one or both of the supplied arguments are text values that can not be interpreted as dates