# DAYS360

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



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](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsdatetime)
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](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDAY) \| [DATEVALUE](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsDtoG/FunctionDATEVALUE) \| [Date and Time Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsdatetime)