Value1
The number to subtract from (the minuend ).
Value2
The number which should be substracted from the first number (the subtrahend ).
Returns
The difference between the numbers.
Subtracts one number from another and returns the result. 8 - 38 - 3 returns 5.
This operator also works with arrays. { 8, 9 } - 6{ 8; 9 } - 6 returns the array { 2, 3 }{ 2; 3 } (equivalent to { 8 - 6, 9 - 6 }{ 8 - 6; 9 - 6 }) and { 8, 9 } - { 6, 10 }{ 8; 9 } - { 6; 10 } returns the array { 2, - 1 }{ 2; - 1 } (equivalent to { 8 - 6, 9 - 10 }{ 8 - 6; 9 - 10 }).
Subtracting many values
The SUM function is equivalent to this operator, provided that all parameters other than the first one are negated.
These formulas both return 5:
However, SUM can be invoked with arrays with an arbitrary number of elements. To subtract the elements of NumberArray from the value of Value1 and return the result, use this formula:
Value1
The date to subtract a number of days from.
Value2
The number of days to subtract.
Returns
The date arrived at by subtracting the given number of days from the given date.
Value1
The date to subtract from (the minuend ).
Value2
The date which should be subtracted from the first date (the subtrahend ).
Returns
The number of days between the given dates.
Subtracts one date from another and returns the number of days between them. DATE (2024, 1, 8) - DATE (2024, 1, 1) DATE (2024; 1; 8) - DATE (2024; 1; 1) returns 7.
Unlike the other operators working with dates, this operator returns a number and not a date. The difference between two dates is a count of days, and not itself a point in time.
The returned number of days need not be a whole number, as the times of day of the given dates are taken into account. If the first date precedes the second one, a negative number is returned.