Spread Formula Reference
DAYS360

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:

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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options