DAYS360 (date1,date2,method)
DAYS360 returns the number of days from date1 to date2 following a 360-day calendar in which all months are assumed to have 30 days.
-
If method is 1, the European method will be used. In this case, if the day of the month is 31 it will be considered as 30.
-
If method is 0 or omitted, the MS Excel (tm) US method will be used. This is a somewhat complicated industry standard method where the last day of February is considered to be the 30th day of the month, but only for the first date.
-
If method is 2, a saner version of the US method is used in which both dates get the same February treatment.
-
Note that Gnumeric will perform regular string to serial number conversion for you, so you can enter a date as a string.
-
This function is mostly Excel compatible.
DAYS360(DATE(2003, 2, 3), DATE(2007, 4, 2)) equals 1499.