DAYS360

Description

Returns the number of days between two dates based on a 360-day year (twelve 30-day months).

Syntax

DAYS360 ( StartDate, EndDate, [ method ] )

Parameter Description
StartDate The first date used in the calculation.
EndDate The second date used in the calculation.
method A logical value that specifies which method to use in the calculation, European or US:
  • False (or omitted) — US (NASD) method is used.
  • True — European method is used.

Remarks

StartDate and EndDate can be text strings using numbers to represent the month, day, and year (for example, "1/30/93" or "1-30-93"), or they can be serial numbers representing the dates.

If StartDate occurs after EndDate, DAYS360 returns a negative number.

If method is set to False and StartDate is the 31st of a month, it becomes equal to the 30th of the same month. If EndDate is the 31st of a month and StartDate is less than the 30th of a month, the ending date becomes equal to the 1st of the next month, otherwise the ending date becomes equal to the 30th of the same month.

If method is set to True, StartDates or EndDates which occur on the 31st of a month become equal to the 30th of the same month.

Examples

The following function returns 1:

 

DAYS360 ( "1/30/15", "2/1/15" )