The DAYS360 function returns the number of days between two dates based on a 360-day year.
Formula:
=DAYS360(start_date,end_date,[method])
Explanations:
- Start_date is required, the start date you need to have the number of days between two dates.
- End_date is required, the end date you need to have the number of days between two dates.
- Method is optional, a logical value for US method or European method, see below:
| Logic | Method | Meanings |
| False or omitted | U.S. method | If the starting date is the last day of a month, it becomes the 30th day of the same month. |
| False or omitted | U.S. method | If the ending date is the last day of a month and the starting date is earlier than the 30th, the ending date becomes the 1st day of the next month; otherwise the ending date becomes the 30th day of the same month. |
| True | European method | Date that occurs on the 31st day of a month becomes 30th day of the month. |
Cautions:
Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.
