This function returns the number of days between two dates based on a 360-day year.

Syntax

DAYS360(startdate,enddate,method)

Arguments

This function has these arguments:

Argument	Description
startdate	Date from which to calculate days
enddate	Date to which to calculate days
method	[Optional] Method for calculating days; if FALSE or omitted, uses U.S. (NASD) method; if TRUE, uses European method.

Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4). For more details on the date inputs, refer to the discussion in Date and Time Functions

The methods for calculating the number of days can vary. The U.S. or NASD method works as follows:

• 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 earlier than the 30th of a month, the ending date becomes equal to the 1st of the next month.
• If the ending date is the 31st of a month and the starting date is the 30th or 31st of a month, the ending date becomes equal to the 30th of the ending date month.

The European method considers starting dates or ending dates that occur on the 31st of a month to be equal to the 30th of the same month.

Remarks

Use this function to help compute payments if your accounting system is based on a 360-day year (twelve 30-day months).

Data Types

Accepts numeric, string, or DateTime object data for the two date arguments and boolean for the method argument. Returns numeric data.

Examples

DAYS360(B8,C8)

DAYS360(R8C2,R8C3)

DAYS360("7/15/2004","12/25/2004") gives the result 160

Version Available

This function is available in product version 1.0 or later.

See Also

DAY | DATEVALUE | Date and Time Functions