From c05b9fe8a6e6cadad0de7821bd33fa5cc283c8e4 Mon Sep 17 00:00:00 2001 From: xuri Date: Fri, 24 Sep 2021 08:19:48 +0800 Subject: new formula function: DAYS, ref #65 --- calc_test.go | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'calc_test.go') diff --git a/calc_test.go b/calc_test.go index 1e4d99b..54629a6 100644 --- a/calc_test.go +++ b/calc_test.go @@ -979,6 +979,10 @@ func TestCalcCellValue(t *testing.T) { "=DAY(\"3-February-2008\")": "3", "=DAY(\"01/25/20\")": "25", "=DAY(\"01/25/31\")": "25", + // DAYS + "=DAYS(2,1)": "1", + "=DAYS(INT(2),INT(1))": "1", + "=DAYS(\"02/02/2015\",\"01/01/2015\")": "32", // MONTH "=MONTH(42171)": "6", "=MONTH(\"31-May-2015\")": "5", @@ -2040,6 +2044,12 @@ func TestCalcCellValue(t *testing.T) { "=DAY(\"3-January-9223372036854775808\")": "#VALUE!", "=DAY(\"9223372036854775808-January-1900\")": "#VALUE!", "=DAY(\"0-January-1900\")": "#VALUE!", + // DAYS + "=DAYS()": "DAYS requires 2 arguments", + "=DAYS(\"\",0)": "#VALUE!", + "=DAYS(0,\"\")": "#VALUE!", + "=DAYS(NA(),0)": "#VALUE!", + "=DAYS(0,NA())": "#VALUE!", // MONTH "=MONTH()": "MONTH requires exactly 1 argument", "=MONTH(0,0)": "MONTH requires exactly 1 argument", -- cgit v1.2.1