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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.