Excel DAYS360 Function
Associated Files Download Links
In this Article
This tutorial demonstrates how to use the Excel DAYS360 Function in Excel to count the number of days between dates.
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:
(Notice how the formula inputs appear)
DAYS360 Function Syntax and Inputs:
|
1 |
=DAYS360(start_date,end_date,method) |
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:
|
1 |
=DAYS(C3,B3) |
Notice the DAYS360 function assumes each month has 30 days. So the difference is calculated as 4months * 30days/month = 120 days.
|
1 |
=DAYS360(B3,C3) |
The DAYS360 Function allows you to switch between the Default US method (FALSE), and the European method (TRUE):
|
1 |
=DAYS360(B3,C3,FALSE) |
|
1 |
=DAYS360(B3,C3,TRUE) |
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:
|
1 |
=DAYS360(TODAY(),B3) |
This example also makes use of the TODAY Function.
NETWORKINGDAYS
The NETWORKINGDAYS Function will calculate the number of business days between dates:
|
1 |
=NETWORKDAYS(B3,C3) |
DAYS360 in Google Sheets
The DAYS360 Function works exactly the same in Google Sheets as in Excel:
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
Range("C2") = Application.WorksheetFunction.Days360(Range("A2"), Range("B2"), False) Range("C3") = Application.WorksheetFunction.Days360(Range("A3"), Range("B3"), False) Range("C4") = Application.WorksheetFunction.Days360(Range("A4"), Range("B4"), False) Range("C5") = Application.WorksheetFunction.Days360(Range("A5"), Range("B5"), False) Range("D2") = Application.WorksheetFunction.Days(Range("B2"), Range("A2")) Range("D3") = Application.WorksheetFunction.Days(Range("B3"), Range("A3")) Range("D4") = Application.WorksheetFunction.Days(Range("B4"), Range("A4")) Range("D5") = Application.WorksheetFunction.Days(Range("B5"), Range("A5")) Range("E2") = Application.WorksheetFunction.NetworkDays(Range("A2"), Range("B2")) Range("E3") = Application.WorksheetFunction.NetworkDays(Range("A3"), Range("B3")) Range("E4") = Application.WorksheetFunction.NetworkDays(Range("A4"), Range("B4")) Range("E5") = Application.WorksheetFunction.NetworkDays(Range("A5"), Range("B5")) |
will produce the following results
Return to the List of all Functions in Excel
