DAYS360

Description

Use this function to return the count of days between two specified dates based on a 360-day year. Supported in Chains.

In this year, all months are assumed to have 30 days.

Syntax

DAYS360(start_date,end_date,[method])

Inputs

This function has the following arguments:

Name Required Valid input

start_date

Yes

First date of the range to be considered. This can be a cell reference, an integer date, or a date in the format "DD/MM/YYYY" or "YYYY/MM/DD".
A formula which results in one of these is also acceptable. Quotation marks are required.

end_date Yes Last date of the range to be considered. This can be a cell reference, an integer date, or a date in the format "DD/MM/YYYY" or "YYYY/MM/DD".
A formula which results in one of these is also acceptable. Quotation marks are required.

method

TRUE or FALSE

When method is FALSE (default) DAYS360 uses the US method to compute days. In this method, when the start date is the last day of a month, it is treated like the 30th day of that month.
The end date is considered to be the 30th of the same month as the start date, unless the end date is the last day of a month and the start date is less than 30 days earlier, in which case the end date is treated as the 1st of the next month.

If method is TRUE, DAYS360 uses the European method to calculate days. In this method, if a start or end dates is the 31st of a month, they are set to the 30th of the month.

Examples

Sample data

A	B	C
2/28/2023	12/6/2024	TRUE
36711	November 30, 2000	FALSE
7/19/2003	Friday, May 31, 2002	45
12/23/2013	January 23, 2014	Orange

Sample formulas

Formula	Description	Result
`=DAYS360("7/19/2003","9/19/2003")`	Determines the difference between the supplied dates, with no method specified.	60
`=DAYS360(A1,B1)`	Determines the difference between the date in cell A1 and the cell B1, with no method specified.	636
`=DAYS360(A1,B1,FALSE)`	Determines the difference between the date in cell A2 and the cell B2, using the US method.	636
`=DAYS360(A1,B1,C1)`	Determines the difference between the date in cell A2 and the cell B2, using the European method, identified by referencing cell C1.	638
`=DAYS360(A4,B4,C4)`	Determines the difference between the date in cell A4 and the cell B4, referencing cell C4.	#VALUE! (because C4 is neither TRUE nor FALSE)

Notes

Wildcards don't work with this function.
The day value can be a numeric value or a US or European format date, but if a text date format is used, both dates must be in the same pattern. These dates must be in quotation marks.
The method value can be referenced for another cell.
If the start_date is after the end_date. the result will be a negative number.
DAYS360 only works with whole numbers and ignores time.
If dates aren't recognized, DAYS360 returns the #VALUE! error.
If dates are out of range, DAYS360 returns the #NUM! error.

Related functions

DATE
DATEVALUE
DAY
DAYS
DAYS360
EDATE
EOMONTH
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
WEEKDAY
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC

Workiva Support Center