Microsoft® Excel® 2010 Formulas & Functions Inside Out

DAYS360()

Syntax. DAYS360(start_date,end_date,method)

Definition. This function calculates the number of days between the start and end dates based on a year with 360 days.

Arguments

• start_date (required). The start date of the interval

• end_date (required). The end date of the interval

• method (optional). A logical value indicating whether the U.S. or European method is used for the calculation:

  • FALSE or Omitted. U.S. (NASD) method. If the starting date is the last day of a month, the starting date becomes equal to the thirtieth day of the same month. If the ending date is the last day of a month and the starting date is earlier than the thirtieth day of a month, the ending date becomes equal to the first day of the next month; otherwise, the ending ...