Index: src/testcases/org/apache/poi/ss/formula/functions/TestDays360.java =================================================================== --- src/testcases/org/apache/poi/ss/formula/functions/TestDays360.java (revision 1757106) +++ src/testcases/org/apache/poi/ss/formula/functions/TestDays360.java (working copy) @@ -67,6 +67,24 @@ confirm(-2, makeDate(1993, 2, 28), makeDate(1993, 2, 28), false); confirm(3, makeDate(1993, 2, 28), makeDate(1993, 3, 1), true); confirm(2, makeDate(1996, 2, 29), makeDate(1996, 3, 1), true); + + // bug 60029 + Date start = makeDate(2018, 02, 28); + Date end = makeDate(2018, 03, 31); + confirm(30, start, end, false); + + // examples from https://support.office.com/en-us/article/DAYS360-function-B9A509FD-49EF-407E-94DF-0CBDA5718C2A + start = makeDate(2011, 01, 30); + end = makeDate(2011, 02, 01); + confirm(1, start, end, false); + + start = makeDate(2011, 01, 01); + end = makeDate(2011, 12, 31); + confirm(360, start, end, false); + + start = makeDate(2011, 01, 01); + end = makeDate(2011, 02, 01); + confirm(30, start, end, false); } private static void confirm(int expResult, int y1, int m1, int d1, int y2, int m2, int d2) {