Subtract

Properties

Enter the value to subtract from

Minuend. Enter an integer, float value, or date (as a literal preceded by =, or an integer or float variable).  

Enter the value to subtract

Subtrahend. Enter an integer or float value (as a literal preceded by =, or an integer or float variable).

Enter a variable value to hold the result

Difference. Enter an integer or float variable. Use the latter if either the subtrahend or the minuend is a float value. A variable value, if used for the minuend or subtrahend, can be used here in which case it will be overwritten by this value.

Exit point

Subtracting date values

When subtracting full dates (not date elements), the minuend and subtrahend must both be date variables, and the difference must be stored in an integer variable. The difference is stored in the unit of seconds with a positive value indicting that an older date was subtracted from a more recent date, and a negative value indicating the reverse.

To avoid unexpected results when subtracting date elements, all fields should refer to the same date element.

The action cell normalises a date element during a subtract operation. For example, subtracting 4 from the month element of 20 January 2018 element results in 20 September 2017.