DAYS360
Syntax:
DAYS360 ( start-date , end-date [ , method-flag ] )
Description: Computes the signed number of days between two dates based on a 360-day year (twelve 30-day months).
Arguments:
Name |
Type |
Description |
||||||
---|---|---|---|---|---|---|---|---|
start-date |
number |
start-date and end-date are the dates for which the difference is to be computed. start-date can be earlier than, the same as, or later than end-date. |
||||||
start-date |
number |
|||||||
method-flag |
logical |
Specifies whether to use the U.S. or European method in the calculation, as follows:
|
Return Type and Value: number – The signed number of days between two dates based on a 360-day year (12 30-day months). If start-date is later than end-date, the return value shall be negative, and the magnitude shall be the difference in days.
However, if start-date or end-date is out of range for the current date base value, #NUM!
is returned.