How to Use DAYS360 Function

The DAYS360 function returns the number of days between two dates based on a 360-day year.

Formula:

=DAYS360(start_date,end_date,[method])

Explanations:

  • Start_date is required, the start date you need to have the number of days between two dates.
  • End_date is required, the end date you need to have the number of days between two dates.
  • Method is optional, a logical value for US method or European method, see below:
LogicMethodMeanings
False or omittedU.S. methodIf the starting date is the last day of a month, it becomes the 30th day of the same month.
False or omittedU.S. methodIf the ending date is the last day of a month and the starting date is earlier than the 30th, the ending date becomes the 1st day of the next month; otherwise the ending date becomes the 30th day of the same month.
TrueEuropean methodDate that occurs on the 31st day of a month becomes 30th day of the month.

Cautions:

Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.

Download: DAYS360 Function

Leave a Reply