SpreadJS Documentation
Operators with Dates and Times
SpreadJS Documentation > Formula Reference > Formula Overview > Operators in a Formula > Operators with Dates and Times

You can use several of the operators with dates and times as summarized here:

Operator Type of Operation Result
Plus + TimeSpan TimeSpan
Negate - TimeSpan TimeSpan
Add DateTime + TimeSpan DateTime
Add TimeSpan + DateTime DateTime
Add TimeSpan + TimeSpan TimeSpan
Subtract DateTime - DateTime TimeSpan
Subtract DateTime - TimeSpan DateTime
Subtract TimeSpan - TimeSpan DateTime

The same order of precedence applies, including use of parentheses, as described in Order of Precedence.

If a DateTime or TimeSpan calculation results in an exception (for example, an OverflowException), the operator returns the #NUM! error.