diff options
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 8deab93..cea9521 100644 --- a/calc_test.go +++ b/calc_test.go @@ -962,6 +962,9 @@ func TestCalcCellValue(t *testing.T) { "=DAY(\"3-February-2008\")": "3", "=DAY(\"01/25/20\")": "25", "=DAY(\"01/25/31\")": "25", + // MONTH + "=MONTH(42171)": "6", + "=MONTH(\"31-May-2015\")": "5", // Text Functions // CHAR "=CHAR(65)": "A", @@ -1981,6 +1984,12 @@ func TestCalcCellValue(t *testing.T) { "=DAY(\"3-January-9223372036854775808\")": "#VALUE!", "=DAY(\"9223372036854775808-January-1900\")": "#VALUE!", "=DAY(\"0-January-1900\")": "#VALUE!", + // MONTH + "=MONTH()": "MONTH requires exactly 1 argument", + "=MONTH(43891,43101)": "MONTH requires exactly 1 argument", + "=MONTH(-1)": "MONTH only accepts positive argument", + "=MONTH(\"text\")": "#VALUE!", + "=MONTH(\"January 25, 100\")": "#VALUE!", // NOW "=NOW(A1)": "NOW accepts no arguments", // TODAY |