Description
Unlike the DAYS and DATEDIF function, in which, excel calculates the actual days between two dates this function is used to return days between two dates assuming 360 days in a year (in other words assuming 30days in each month).
=DAYS360(start_date,end_date,method)
The DAYS function syntax has the following arguments:
- Start_date Required.
A date that represents the start date.
-
End_date Required.
A date that represents the start date.
If start_date occurs after end_date, the DAYS360 function returns a negative number. Dates should be entered by using the DATE function or derived from the results of other formulas or functions.
- Method Optional.
A logical value that specifies whether to use the U.S. or European method in the calculation.
