Overview
| Syntax | DAYS360(Start_date,End_date,Method) | 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. You can use this function to help compute payments if your accounting system is based on twelve 30-day months. |
|---|---|---|
| Parameter 1 | Start_date | The Start_date and End_date parameters are two dates between which you want to know the number of days. |
| Parameter 2 | End_date | |
| Parameter 3 | Method | Represents the logical value that specifies whether to use the U.S. or European method in the calculation. Definition: If the method is set to FALSE or be empty, the U.S. (NASD) method is used. If the method is set to TRUE, the European method is used, where starting dates and ending dates that occur on the 31st day of a month become equal to the 30th day of the same month. |
Notes
Direct-connected data is not supported.
The function supports three parameters. The third parameter can be the default value or of the text or numeric type. The first two parameters can be of the date or text types.
The true(TRUE) and false(FALSE) in the Method parameter are case-insensitive and marked in blue.
Example
| Formula | Result | Note |
|---|---|---|
DAYS360("1998/1/30","1998/2/1") | 1 |
