DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel

The following article details how to use the DAYS360 function, the function finds the number of days between two dates based on a 360-day year in Excel.

Description: The DAYS360 function is used to calculate the number of days based on a year of only 360 days. The function is usually used to calculate payments if your accounting system is based on a 360-day year.

Syntax: DAYS360 (start_date, end_date, [method]) .

Inside:

- start_date : The start date.

- end_date : End date.

- method : The basis used to count dates, is an arbitrary parameter, the default is False and has the following values:

+ method = False -> US Method (NASD), If the start date is the last day of the month, it will be equal to the 30th day of the month. If the start date is the end of the month and the start date is earlier than the 30th day of the month, the end date will be the first day of the next month, whereas the end date will be equal to the 30th day of that month.

+ method = True -> The basis of calculating date is based on European calculation, the start date and end date if taking place on the 31st of the month will be equal to the 30th day of that month.

For example:

Calculating the number of days from 6/15/2015 to 5/1/2016.

DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel Picture 1

- Use a European-standard date counting facility.

In the cell to calculate enter the formula: = DAYS360 (D6, D7, D8) .

DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel Picture 2

Press Enter -> the number of days from 6/15/2015 to 5/1/2016 is:

DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel Picture 3

- Similarly, according to North American standards, the number of days is:

DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel Picture 4

The actual case from 1/15/2015 to 1/15/2016 has 365 days but when using DAYS360 function, the number of days from 1/15/2015 to 1/15/2016 is only 360 days.

DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel Picture 5

The above is the usage as well as some notes when using the DAYS360 function .

Good luck!