Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
Syntax
DAYS360(start_date,end_date,method)
Start_date and end_date are the two dates between which you want to know the number of days. If start_date occurs after end_date, DAYS360 returns a negative number.
Method is a logical value that specifies whether to use the U.S. or European method in the calculation
|
Method |
Defined |
|
FALSE or omitted |
U.S. (NASD). If the starting date is the 31st of a month, it becomes equal to the 30th of the same month. If the ending date is the 31st of a month and the starting date is less than the 30th of a month, the ending date becomes equal to the 1st of the next month, otherwise the ending date becomes equal to the 30th of the same month. |
|
TRUE |
European method. Starting dates or ending dates that occur on the 31st of a month become equal to the 30th of the same month. |
Tip To determine the number of days between two dates in a normal year, you can use normal subtraction — for example, "12/31/93"-"1/1/93" equals 364.
Example
DAYS360("1/30/93", "2/1/93") equals 1
If cell D10 contains the date 1/30/93 and cell D11 contains the date 2/1/93, then:
DAYS360(D10, D11) equals 1