DAYS360 
DAYS360(start_date, end_date [,method]) 
Returns the number of days between two dates, based on 30 day months. 
start_date  The first date or starting date of the period. 
end_date  The 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 

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