| Operator/Function | Description | Operand Types | Result Type | |
|---|---|---|---|---|
| First | Second | |||
| − | Subtract | D | DN | ND |
| + | Add | D | N | D |
| DATETONR or DATETONUM | Convert date to a number | D |
|
N |
| DAY | Day part of date | D |
|
N |
| MONTH | Month part of date | D |
|
N |
| NRTODATE or NUMTODATE | Convert number to date | N |
|
D |
| SETDAYS | Set day part of date | D | N | D |
| SETMONTHS | Set month part of date | D | N | D |
| SETYEARS | Set year part of date | D | N | D |
| YEAR | Year part of date | D |
|
N |