Here is a dataset that shows a person’s salary and expenses. You can perform subtraction of values from different cells using cell references. Method 1: Finding Differences Between Two Cells by Using Subtraction Formula in Excel Here, we will show how to determine the date of differences between two dates and the time of differences between two times, calculate percentages, find the differences between two cells, and subtract a specific cell value from any cell range by using the Subtraction formula in Excel. This article will demonstrate how to apply the Subtraction formula in Excel to determine different criteria according to different data sets and how to subtract from text to text by combining the TRIM and SUBSTITUTE functions to subtract Case-Sensitive text and merging the TRIM, REPLACE, SEARCH, and LEN functions to subtract Case-Insensitive text. In this tutorial, we used a simple example to demonstrate how we can add or subtract weeks from a date in Excel to highlight a particular set of data.8 Suitable Ways to Apply Subtraction Formula in Excel Now we can get all the other results by dragging down from the right corner of the first result to get our final output. To subtract three weeks, click on an empty cell in Excel and enter the formula =A2-7*3. Let us consider the same data that we used in the addition of weeks, which is the data used in the above example. Now let us see the simple process for subtracting weeks from the date. Here, we will first use the formula to get the first result, then use the auto-fill handler to get all the results. We can create all the other results by dragging down from the right corner of the first result until all the other results are acquired.

Now click on an empty cell beside the date and enter the formula =A2+7*3 to add two weeks to the date, then click on Enter to get the first result.

Let's make an Excel sheet with a single column containing a list of dates. Let's look at a simple procedure for adding weeks to a date in Excel.

So, let's see a simple process to add or subtract the number of weeks in the Excel sheet using the formula. We can make it happen very easily, using the formulas supported by Excel. Making the adjustments to the dates manually is a very complex and hectic process. Making changes to deadlines in Excel is one of the most common tasks performed there.

Subtract formula excel