# DAYS360 Function – Examples in Excel, VBA, Google Sheets

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:

``=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:

``=DAYS(C3,B3)``

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

``=DAYS360(B3,C3)``

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

``=DAYS360(B3,C3,FALSE)``

``=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:

``=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:

``=NETWORKDAYS(B3,C3)``

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

``````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