Excel DAYS360 Function

This tutorial demonstrates how to use the Excel DAYS360 Function in Excel to count the number of days between dates.

DAYS360 Main Function

DAYS360 Function Overview

The DAYS360 Function Returns the number of days between two dates based on a 360 day year.

To use the DAYS360 Excel Worksheet Function, select a cell and type:
days360 formula syntax

(Notice how the formula inputs appear)

DAYS360 Function Syntax and Inputs:

start_date – The start date in Excel serial number format or entered as a date with quotations (“s) surround the date. Example: You can not enter 11/12/2015 directly into the cell. Instead you need to enter “11/12/2015” or you would need to use the corresponding serial number: 42320. Alternatively, you can reference a cell with the date 11/12/2015 entered. Excel automatically converts dates stored in cells into serial format (unless the date is entered as text).

end_date – The end date in Excel serial number format or entered as a date with quotations (“s) surround the date. Example: You can not enter 11/12/2015 directly into the cell. Instead you need to enter “11/12/2015” or you would need to use the corresponding serial number: 42320. Alternatively, you can reference a cell with the date 11/12/2015 entered. Excel automatically converts dates stored in cells into serial format (unless the date is entered as text).

method – OPTIONAL. TRUE for European method. FALSE for US method. If ommitted, default to FALSE (US Method). Example: TRUE.

 

Calculate Number of Days Between Dates (Based on 360-day Year)

The DAYS360 function returns the number of days between two dates based on a 360-day year where each month is considered to have 30 days. Notice the difference between the DAYS Function and the DAYS360 Function:

DAYS360 days Four monthsNotice the DAYS360 function assumes each month has 30 days. So the difference is calculated as 4months * 30days/month = 120 days.

DAYS360 Four monthsThe DAYS360 Function allows you to switch between the Default US method (FALSE), and the European method (TRUE):

Days 360 US Method

Days 360 European method

Days From Today (360)

This example will show how to calculate the number of days from a date to today using the 360-day year:

360Days From TodayThis example also makes use of the TODAY Function.

NETWORKINGDAYS

The NETWORKINGDAYS Function will calculate the number of business days between dates:

DAYS360 NETWORKING DAYSDAYS360 in Google Sheets

The DAYS360 Function works exactly the same in Google Sheets as in Excel:

DAYS360 Google sheet

DAYS360 Examples in VBA

You can also use the DAYS360 function in VBA. Type:
application.worksheetfunction.days360(start_date,end_date,method)
For the function arguments (start_date, etc.), you can either enter them directly into the function, or define variables to use instead.

Executing the following VBA statements

will produce the following results

Vba DAYS360 function

 

 

Return to the List of all Functions in Excel