Now first calculating the difference between two dates in excel so apply the B2 A2 formula. The criteria to create a formula for subtraction in excel is It should always begin with an equal sign. You can type the numbers involved in the subtraction directly in the formula or place the numbers in a cell.
The solution to subtract several numbers with a number without using a formula is to use special paste.
How to subtract columns in Excel To subtract 2 columns row-by-row write a minus formula for the topmost cell and then drag the fill handle or double-click the plus sign to copy the formula to the entire column. An alternative but more long-winded calculation would be to calculate 10 of the number and then subtract it from the original number with one of these formulas. Select cell B5 and click in the fx bar to enter a formula. You have to use the mathematical operator minus sign - to subtract two numbers.