From 00f6289b2f14f3c69e8893b4df62ad30c005ea20 Mon Sep 17 00:00:00 2001 From: PJ Fanning Date: Sat, 28 May 2022 18:15:21 +0000 Subject: [PATCH] [bug-58468] implement DAYS function git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1901363 13f79535-47bb-0310-9956-ffa450edef68 --- .../test/java/org/apache/poi/ss/formula/functions/TestDays.java | 1 + 1 file changed, 1 insertion(+) diff --git a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDays.java b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDays.java index 575eb7a5aa..6acfb2b76a 100644 --- a/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDays.java +++ b/poi/src/test/java/org/apache/poi/ss/formula/functions/TestDays.java @@ -45,6 +45,7 @@ public class TestDays { HSSFCell cell = wb.getSheetAt(0).getRow(0).createCell(12); assertDouble(fe, cell, "DAYS(\"15-MAR-2021\",\"1-FEB-2021\")", 42, 0.00000000001); assertDouble(fe, cell, "DAYS(A2,A3)", 364, 0.00000000001); + assertDouble(fe, cell, "DAYS(\"1-FEB-2021\", \"15-MAR-2021\")", -42, 0.00000000001); } } -- 2.39.5