DAYS360

Excel Functions

Get days between 2 dates in a 360-day year

Syntax

EXCEL

=DAYS360(start_date, end_date, [method])

Arguments

Parameter	Description
`start_date`	The start date.
`end_date`	The end date.
`method`	[optional] Day count method. FALSE (default) = US method, TRUE = European method.

Return Value

A number representing days.

Details

The DAYS360 function returns the number of days between two dates, based on a year where all months have 30 days. Both dates must be valid Excel dates or text values that can be parsed as dates. The DAYS360 function only works with whole numbers, time values are ignored. DAYS360 takes an optional argument called method that can be set to either TRUE or FALSE. When method is FALSE (default) DAYS360 uses a US method to compute days. When the start date is the last day of the month, it is treated like the 30th day of that month. When the end date is the last day of the month, and the start date is less than 30, the end date is treated as the 1st of the next month, otherwise the end date is treated like the 30th of the same month. If method is set to TRUE, DAYS360 uses a European method to cal

Examples

In the formula below, DAYS360 returns 360 days with a start date of January 1, 2021 and an end date of December 31, 2021.

EXCEL

=DAYS360("1-Jan-2021","31-Dec-2021") // returns 360

Examples

With a start date of July 1, 2021 in A1, and an end date of December 31, 2021 in B1, the formula below returns 180:

EXCEL

=DAYS360(A1,B1) // returns 180

Examples

To create a date from scratch in a formula, use the DATE function. The formula below returns 90:

EXCEL

=DAYS360(DATE(2021,1,1),DATE(2021,4,1)) // returns 90

DAYS360

Syntax

Arguments

Return Value

Details

Examples

See Also