Excel DAYS360 Function

Excel DAYS360 Function

Sponsored Link

Purpose 

Get days between 2 dates in a 360-day year

Return value 

A number representing days.

Syntax 

=DAYS360 (start_date, end_date, [method])

Arguments 

  • start_date – The start date.
  • end_date – The end date.
  • method – [optional] The type of day count basis to use. FALSE (default) is US method, TRUE is European method.

Usage notes 

Notes on method:

FALSE – (default) – US method. when the start date is the last day of the month, it is set to the 30th day of the same month. When the end date is the last day of the month, and the start date < 30, the end date is set to the 1st of the next month, otherwise the end date is set to the 30th of the same month.

TRUE – European method. Starting dates and ending dates equal to the 31st of a month are set to the 30th of the same month.

Sponsored Link

1 votes. 4.5 / 5

Excel - Excel Functions - Excel Formulas
Logo