This Excel tutorial explains how to use the Excel DAYS360 function with syntax and examples.
The Microsoft Excel DAYS360 function returns the number of days between two dates based on a 360-day year.
The syntax for the DAYS360 function in Microsoft Excel is:
DAYS360( start_date, end_date, [method] )
The DAYS360 function can be used in the following versions of Microsoft Excel:
The DAYS360 function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel DAYS360 function examples and explore how to use the DAYS360 function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following DAYS360 examples would return:
=DAYS360(A1, A2, TRUE) Result: 359 =DAYS360(A3, A2, TRUE) Result: 15 =DAYS360("30-Nov-2012", "1-Dec-2012") Result: 1
(scroll to see more)