To do this, first enter the two dates into the appropriate cells. Using Formulas to Subtract DatesĮxcel can also be used to subtract dates. If the result is negative, the cell will be highlighted in red to indicate that the result is a negative number. The result will be the difference between the two cells. Once the formula has been entered, press the Enter key to display the result in the cell. This formula will subtract the value in cell2 from the value in cell1. The formula should look like this: = (cell1 – cell2). Then, select the cell you want to subtract from and enter the subtraction formula. First, open a new spreadsheet in Excel and enter the desired values into the cells. Creating an Excel Subtraction FormulaĬreating an Excel subtraction formula is easy and can be done in just a few simple steps. In this article, we will discuss how to do a subtraction formula in Excel. Excel allows users to create formulas to subtract numbers from one another, as well as subtract dates, times, and other data. Subtracting in Excel is a great way to quickly and easily perform mathematical calculations. For example, to subtract B3 from A3, C3 from A3, and D3 from A3, type “=A3-B3-C3-D3” into A3 and press Enter. To make multiple subtractions, add the minus sign between each set of values. For example, if you want to subtract B3 from A3, type “=A3-B3” into A3 and press Enter. Type the formula into the cell you want to subtract from, with the minus sign between the two sets of values. How to Do a Subtraction Formula in Excel? To subtract in Excel, use the ‘-‘ sign between two cells or numbers.

Microsoft excel subtraction formula