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 2024", "2 Jan 2024") = 1Monday, Jan 01 2024
2=DAYS360("1/1/2024", "9/1/2024") = 8Tuesday, Jan 02 2024
3=DAYS360(B1, B9) = 8Wednesday, Jan 03 2024
4=DAYS360("1 Jan 2024", "1 Feb 2024") = 30Thursday, Jan 04 2024
5=DAYS360("30 Jan 2024", "02 Feb 2024") = 2Friday, Jan 05 2024
6=DAYS360("31 Jan 2024", "02 Feb 2024") = 2Saturday, Jan 06 2024
7=DAYS360("31 Jan 2024", "02 Feb 2024", TRUE) = 2Sunday, Jan 07 2024
8=DAYS360("1 Jan 2024", "31 Dec 2024") = 360Monday, Jan 08 2024
9=DAYS360("2 Jan 2025", "29 Dec 2024") = -3Tuesday, Jan 09 2024
10=DAYS360(1/1/2024, 31/12/2024) = 0 
11=DAYS360(DATE(2024, 1, 1), DATE(2024, 12, 31)) = 360 
12=DAYS360("28 Feb 2024", "1 Mar 2024", FALSE) = 3 
13=DAYS360("28 Feb 2024", "1 Mar 2024", TRUE) = 3 
14=DAYS360("30 Apr 2024", "1 May 2024", FALSE) = 1 
15=DAYS360("30 Apr 2024", "1 May 2024", 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 2024" and "2 Jan 2024".
2 - How many days between "1/1/2024" and "9/1/2024".
3 - How many days between the dates in cells "B1" and "B9". Between "9 Jan 2024" and "1 Jan 2024".
4 - How many days between "1 Jan 2024" and "1 Feb 2024".
5 - How many days between "30 Jan 2024" and "02 Feb 2024". 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 2024" and "02 Feb 2024". 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 2024" and "02 Feb 2024". 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 2024" and "31 Dec 2024". All months have 30 days.
9 - How many days between "2 Jan 2025" and "29 Dec 2024".
10 - How many days between 1/1/2024 and 31/12/2024. Dates must be entered as text strings or serial numbers.
11 - How many days between 1/1/2024 and 31/12/2024.
12 - How many days between "27 Feb 2024" and "1 Mar 2024". 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 2024" and "1 Mar 2024". This is using European convention. The days being counted are 29 Feb, 30 Feb, 1 Mar.
14 - How many days between "30 Apr 2024" and "1 May 2024". 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 2024" and "1 May 2024". 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.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top