DAYS360 function. Calculate the number of days between two dates, using a year as 360 days (12 months x 30 days).(Microsoft Excel)
Calculate the number of days between two dates, using a year as 360 days (12 months x 30 days)
Contents
How it works
=DAYS360(Start_date, end_date,Method)
| Argument | Omission | Specify |
|---|---|---|
| Start_date | Required argument. | The start date of the period. |
| End_date | Required argument. | The end date of the period. |
| Method | FALSE | FALSE:U.S. (NASD) method. TRUE:European method. |
Example Results
For months in which January is not the 30th, the result is adjusted at the end of the month and the beginning of the month.
Therefore, even if the start and end dates are different, the resulting number of days may be the same.
Also, if the start date is in the future, the result will be a negative number.
Spill
If you specify the argument the cell range, it will be Spill.
---