DAYS360

DAYS360(start_date, end_date [,method])

Returns the number of days between two dates, based on 30 day months.

start_dateThe first date or starting date of the period.
end_dateThe last date or ending date of the period.
method(Optional) A logical value indicating which method to use:
False (or 0) = US convention (default)
True (<> 0) = European convention

REMARKS
* The calendar used is based on a 360 day year with twelve 30 day months.
* The "date" arguments can be entered as text strings within quotation marks, as serial numbers or as results of other formulas or functions.
* If "start_date" is the 31st of a month then the 30th of that month is used.
* If "start_date" > "end_date", then a negative number is returned.
* If "start_date" is not a valid date, then #VALUE! is returned.
* If "end_date" is not a valid date, then #VALUE! is returned.
* If "method" is left blank, then False is used.
* If "method" = "US" and the starting date is the last day of a month (28,29,30 or 31), then the 30th day of that month is used.
* If "method" = "US" and the ending date is the last day of a month (28,29,30 or 31), then the 30th day of that month is used.
* If "method" = "US" and the ending date is the last day of a month (28,29,30 or 31) AND the starting date is earlier than the 30th day of a month, then the ending date becomes the 1st day of the next month.
* If "method" = "European" and the starting date is the 31st day of a month, then the 30th day of that month is used.
* If "method" = "European" and the ending date is the 31st day of a month, then the 30th day of that month is used.
* This function is useful for some accountancy systems that use a 360 day calendar.
* The date format can be any of those found on the "Format Cells" dialog box.
* You can use the DATE function to return the date serial number given a YEAR, MONTH, DAY.
* You can use the DAYS function to return the number of days between two dates.
* You can use the NETWORKDAYS.INTL function to return the number of days excluding weekends and holidays.
* You can use the WORKDAY.INTL function to return a given number of working days before or after a date.
* You can use the YEARFRAC function to return the number of years as a decimal between two dates.
* You can use the DAYSINAMONTH - User Defined Function to return the number of days in a particular month and year.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 AB
1=DAYS360("1 Jan 2022","2 Jan 2022") = 1Saturday, January 01, 2022
2=DAYS360("1/1/2022","9/1/2022") = 8Sunday, January 02, 2022
3=DAYS360(B1,B9) = 8Monday, January 03, 2022
4=DAYS360("1 Jan 2022","1 Feb 2022") = 30Tuesday, January 04, 2022
5=DAYS360("30 Jan 2022","02 Feb 2022") = 2Wednesday, January 05, 2022
6=DAYS360("31 Jan 2022","02 Feb 2022") = 2Thursday, January 06, 2022
7=DAYS360("31 Jan 2022","02 Feb 2022",TRUE) = 2Friday, January 07, 2022
8=DAYS360("1 Jan 2022","31 Dec 2022") = 360Saturday, January 08, 2022
9=DAYS360("2 Jan 2023","29 Dec 2022") = -3Sunday, January 09, 2022
10=DAYS360(1/1/2022,31/12/2022) = 0 
11=DAYS360(DATE(2022,1,1),DATE(2022,12,31)) = 360 
12=DAYS360("28 Feb 2022","1 Mar 2022",FALSE) = 1 
13=DAYS360("28 Feb 2022","1 Mar 2022",TRUE) = 3 
14=DAYS360("30 Apr 2022","1 May 2022",FALSE) = 1 
15=DAYS360("30 Apr 2022","1 May 2022",TRUE) = 1 
16=DAYS360("01/03/2022","31/06/2022",TRUE) = #VALUE! 
17=DAYS360("03/16/2022","03/16/2022") = #VALUE! 

1 - How many days between "1 Jan 2022" and "2 Jan 2022".
2 - How many days between "1/1/2022" and "9/1/2022".
3 - How many days between the dates in cells "B1" and "B9". Between "9 Jan 2022" and "1 Jan 2022".
4 - How many days between "1 Jan 2022" and "1 Feb 2022".
5 - How many days between "30 Jan 2022" and "02 Feb 2022". There are 31 days in January but this function assumes 30. The 31 Jan is ignored. The days being counted are 1 Feb, 2 Feb.
6 - How many days between "31 Jan 2022" and "02 Feb 2022". This is using the US convention. January has 31 days but this function assumes 30. The 31 Jan is ignored. The days being counted are 1 Feb, 2 Feb.
7 - How many days between "31 Jan 2022" and "02 Feb 2022". This is using the European convention. The start_date is 31 Jan so 30 Jan is used. The 31 Jan is ignored. The days being counted are 1 Feb, 2 Feb.
8 - How many days between "1 Jan 2022" and "31 Dec 2022". All months have 30 days.
9 - How many days between "2 Jan 2023" and "29 Dec 2022".
10 - How many days between 1/1/2022 and 31/12/2022. Dates must be entered as text strings or serial numbers.
11 - How many days between 1/1/2022 and 31/12/2022.
12 - How many days between "27 Feb 2022" and "1 Mar 2022". This is using US convention. The start_date is the last day of the month so 30 Feb is used. The days being counted are 1 Mar.
13 - How many days between "28 Feb 2022" and "1 Mar 2022". This is using European convention. The days being counted are 29 Feb, 30 Feb, 1 Mar.
14 - How many days between "30 Apr 2022" and "1 May 2022". This is using US convention. The start date is the last day of the month, so 30 Apr is used. The days being counted are 1 May.
15 - How many days between "30 Apr 2022" and "1 May 2022". This is usng European convention.
16 - There are only 30 days in June, not 31.
17 - The month component is not valid. 16 is not a valid month.
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top