DAYS360 Function
The DAYS360 function is used to calculate the number of days between two dates. It is based on a 360 day calendar.
The DAYS360 function is used to calculate the number of days between two dates. It is based on a 360 day calendar. The arguments for the function are:
=DAYS360(start date, end date, method)
The start date is the first date that you want to use, and the end date is the second. Basically, the function takes (end date – start date) and returns how many days there are in between. It is possible to produce negative values if your start date is chronologically after your end date. The method is an optional value. If left blank, or you enter TRUE, it will base the result on the American calendar. Entering FALSE uses the European method. You can use a variety of date formats for this function. Some example functions using the data shown and their results:
=DAYS360(A1,A2) => 81
=DAYS360(A1,A3,TRUE) => 94
=DAYS360(A4,A3) => -26
