DAYS360

Definition of DAYS360

Returns the difference between two days based on the 360 day year used in some financial interest calculations.

Sample Usage

DAYS360(DATE(1969,7,16),DATE(1969,7,24),1)

DAYS360(A2,A3)

DAYS360(1,270,1)

Syntax

DAYS360(start_date, end_date, [method])

• start_date - The start date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

• end_date - The end date to consider in the calculation. Must be a reference to a cell containing a date, a function returning a date type, or a number.

• method - [ OPTIONAL - 0 by default ] - An indicator of what day count method to use.

  • 0 indicates the US method - Under the US method, if start_date is the last day of a month, the day of month of start_date is changed to 30 for the purposes of the calculation. Furthermore ifend_date is the last day of a month and the day of the month of start_date is earlier than the 30th, end_date is changed to the first day of the month following end_date, otherwise the day of month of end_date is changed to 30.

  • Any other value indicates the European method - Under the European method, any start_date or end_date that falls on the 31st of a month has its day of month changed to 30.

Notes

• This function is mostly used in a financial setting, for calculation involving fixed-income securities. Other usage is likely incorrect.

• Ensure that the inputs to the function are either references to cells containing dates, functions which return date objects such as DATE, DATEVALUE or TO_DATE, or date serial numbers of the type returned by the N function. Functions only accept literal dates in numeric format.

• DAYS360 does not auto-convert number formats. Therefore, DAYS360(10/10/2000,10/10/2001) is interpreted as DAYS360(0.005,0.00499750124938), the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.

See Also

YEARFRAC: Returns the number of years, including fractional years, between two dates using a specified day count convention.

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

DATEVALUE: Converts a provided date string in a known format to a date value.

DATE: Converts a provided year, month, and day into a date.

In order to use the DAYS360 formula, start with your edited Excellentable:

Then type in the DAYS360 Formula in the area you would like to display the outcome:

By adding the values you would like to calculate the DAYS360 formula for, Excellentable will generate the outcome:

	A	B	C	D
1	State	Population	Total area in mi2	Land area in mi2	Water area in mi2	House seat(s)
2	Alabama	4833722	52,420 (135,767)	50,645 (131,170)
3	Alaska	735132	665,384 (1,723,337)	570,641 (1,477,950)
4	Arizona	6626624	113,990 (295,233)	113,594 (294,207)
5	Arkansas	2959373	53,179 (137,733)	52,035 (134,770)
6	California	38332521	163,695 (423,968)	155,779 (403,466)
7	Colorado	5268367	104,094 (269,602)	103,642 (268,432)
8	Connecticut	3596080	5,543 (14,356)	4,842 (12,541)
9	Delaware	925749	2,489 (6,446)	1,949 (5,048)
10	Florida	19552860	65,758 (170,312)	53,625 (138,888)
11	Georgia	9992167	59,425 (153,910)	57,513 (148,958)
12	Hawaii	1404054	10,932 (28,314)	6,423 (16,635)
13	Idaho	1612136	83,569 (216,443)	82,643 (214,044)
14
15

	E	F	G
1

Date

1,775 (4,597)

7

94,743 (245,383)

1

396 (1,026)

9

1,143 (2,960)

4

7,916 (20,502)

53

452 (1,171)

7

701 (1,816)

5

540 (1,399)

1

12,133 (31,424)

27

1,912 (4,950)

14

4,509 (11,678)

2

926 (2,398)

2

DAYS360: