DAYS360 Function Explained
The DAYS360 Function in Microsoft Excel calculates the number of days between two dates based on a 360-day year (twelve 30-day months). It can also optionally consider an initial or ending day count. The syntax for the function is DAYS360(start_date, end_date, [method]).
DAYS360 Function Syntax
DAYS360(start_date, end_date, [method])
- start_date: The start date of the period.
- end_date: The end date of the period.
- method: (Optional) A logical value that specifies the method to use in calculating the difference between two dates. If TRUE or omitted, the U.S. (NASD) method is used; if FALSE, the European method is used.