Spread 8.0 Documentation
DAYS360
Support Options
Formula Reference > Built-In Functions > DAYS360

Glossary Item Box

DAYS 360


Name

Days

Description

Returns the number of days between two dates based on a 360-day year.

Syntax

DAYS360(startdate,enddate,method)

Remarks

This function has the following 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).

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.

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

Data Type

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

Example

DAYS360(B8,C8)
DAYS360(R8C2,R8C3)

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.