This formula uses the WORKDAY function to subtract a specific number of workdays from a date. First select a cell to add the formula to. On the worksheet click the cell in which you want to enter the formula.
Minus Formula in Excel.
At first select cell C2 Input an equal sign Now select the cell reference A2 Now input a minus sign - Then select the cell reference B2 Now press Enter key on your keyboard. To do this youll need to use a very simple Excel formula. In excel we do not have any inbuilt formula for subtraction or minus we use minus operator - to do the arithmetical subtraction in excel to subtract two values from each other we need to also use the equals to operator to make minus a formula for example value 1- value 2 is a minus formula where we subtract value 1 from value 2 note that the values should be in the same format to avoid error in formula. Simple formulas always start with an equal sign followed by constants that are numeric values and calculation operators such as plus minus - asterisk or forward slash signs.