diff options
| author | xuri <xuri.me@gmail.com> | 2021-09-24 08:19:48 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-09-24 08:19:48 +0800 |
| commit | c05b9fe8a6e6cadad0de7821bd33fa5cc283c8e4 (patch) | |
| tree | 7da5ed9337aaf991b41994b8c537567bb6c08506 /calc_test.go | |
| parent | 790c363cceaaa09e91ad579e2d25cb13c1582bba (diff) | |
new formula function: DAYS, ref #65
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 10 |
1 files changed, 10 insertions, 0 deletions
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", |