Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > DAYS360
 

DAYS360(start_date, end_date [,method])

 
 Returns the number of days between two dates, based on 30 day months.

 start_dateThe first date or starting date of the period.
 end_dateThe last date or ending date of the period.
 methodTrue or False to specify whether to use the US or European method.

 REMARKS
 
  		• The calendar used is based on a 360 day year with twelve 30 day months.
     
  		• The "date" arguments can be entered as text strings within quotation marks, as serial numbers or as results of other formulas or functions.
     
  		• If "start_date" is the 31st of a month then the 30th of that month is used.
     
  		• If "start_date" > "end_date", then a negative number is returned.
     
  		• If "start_date" is not a valid date, then #VALUE! is returned.
     
  		• If "end_date" is not a valid date, then #VALUE! is returned.
     
  		• If "method" = False, then any ending dates that occur on the 31st of a month become equal to the 1st of the next month (US).
     
  		• If "method" = True, then any ending dates that occur on the 31st of a month become the 30th of that month (European).
     
  		• If "method" is left blank, then False is used.
     
  		• This function is useful for some accountancy systems that use a 360 day calendar.
     
  		• You can use the NETWORKDAYS() function to return the number of days excluding weekends and holidays.
     
  		• Example 3 & 12 - You should always put your dates as a text string rather than just in a date format.
     
  		• Example 10 - You should always try and use the DATE() function to ensure you get the correct value.

     EXAMPLES
     
     AB
    1=DAYS360("1 Jan 2007","1 Jan 2007") = 01/1/2007
    2=DAYS360("1 Jan 2007","2 Jan 2007") = 11/2/2007
    3=DAYS360("1/1/2007","9/1/2007") = 81/3/2007
    4=DAYS360(B1,B9) = 81/4/2007
    5=DAYS360("1 Jan 2007","30 Jan 2007") = 291/5/2007
    6=DAYS360("1 Jan 2007","31 Jan 2007") = 301/6/2007
    7=DAYS360("1 Jan 2007","1 Feb 2007") = 301/7/2007
    8=DAYS360("30 Jan 2007","02 Feb 2007") = 21/8/2007
    9=DAYS360("31 Jan 2007","02 Feb 2007") = 21/9/2007
    10=DAYS360("1 Jan 2007","31 Dec 2007") = 360 
    11=DAYS360("14 Jan 2007","1 Jan 2007") = -13 
    12=DAYS360(1/1/2007,31/12/2007) = 0 
    13=DAYS360(DATE(2007,1,1),DATE(2007,12,31)) = 360 
    14=DAYS360("1/30/1998","2/1/1998") = #VALUE! 
    15=DAYS360("01/03/2004","31/06/2004",TRUE) = #VALUE! 
    		 
     Functions - D | Index - D | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top