Souptik Roy
While working with a dataset, sometimes you need to add or subtract dates. You can easily Add and Subtract Dates in Excel. In this article, I will show you How to Add and Subtract Dates in Excel with 4 Handy Methods. I hope you will find interest in these methods and may increase your skill by practicing the methods.
Download Practice Workbook
Please download the practice workbook to practice yourself.
4 Effective Methods to Add and Subtract Dates in Excel
Let’s consider a dataset of the Product Arrival Date of ABC Company. The dataset has 2 columns B and C meaning Product Name and Arrival Date respectively. The dataset ranges from B4 to C10 cells. Without further delay let’s start to follow the steps of each method. I will show the necessary illustrations for your better understanding.
1. Use Generic Formula to Add and Subtract Dates in Excel
This is the first method that I am going to show you. In this method, I will use a Generic Formula to Add and Subtract Date in Excel. Let’s follow the method step by step.
Steps:
- First, you will find that I have added two new columns in the dataset called Due Days and New Arrival Days.
- Enter the following formula in cell E5.
=C5+D5
- After that, Press the Enter.
- Then, Fill Handle the formula from E5 to E10.
- At last, you will find the result just like the picture given below.
Read More: Adding and Subtracting in Excel in One Formula (4 Easy Ways)
2. Apply EDATE Function to Add and Subtract Months from Dates
I would like to introduce the EDATE Function to Add and Subtract Months from Dates in this method. This is a straightforward process. Just follow the steps to be familiar with the method.
Steps:
- At first, you will find the blank column of New Arrival Date.
- However, Select the E5 cell.
- Then, Write down the following formula in the selected cell.
=EDATE(C5, D5)- After that, Press the Enter.
- Then, you will find the result like the picture given below.
- After that, Fill Handle the formula from E5 to E10.
- As a result, you will find the output like the image given below.
Read More: How to Add or Subtract Based on Cell Value in Excel (3 Ways)
3. Merge DATE, YEAR, MONTH, and DAY Functions to Add and Subtract Years
This is the third method to Add and Subtract Years from Date. I will use a Generic Formula here. Hope you will understand the method easily after following the steps with the necessary illustrations.
Steps:
- At the very first, you will find the following table.
- Then Select the E5 cell.
- Write down the formula given below.
=DATE(YEAR(C5)+D5,MONTH(C5),DAY(C5))- After that, Press Enter.
- you will find the output in the selected cell just like the picture given below.
- Moreover, Fill-Handle the formula from E5 to E10
- Last, you will find the result just like the picture given below.
Read More: How to Add and Subtract in One Cell in Excel (6 Ways)
4. Combine DAYS, MONTHS, and YEARS Functions to Add and Subtract Dates in Excel
This is the last method of this article. This is another handy and smart method. I will use a combination of DAYS, MONTHS, and YEARS functions to Add and Subtract Dates in Excel. Please follow the steps and illustrations to understand the method properly. I hope you will find interest in this method.
Steps:
- In the data table, you will see new columns called Years, Months, and Days. I will use them to solve the problem.
- Select the G5
- Write down the following formula in the selected cell.
=DATE(YEAR(C5)+D5,MONTH(C5)+E5,DAY(C5)+F5)- Then, Press the Enter.
- After that, you will find the result just like the picture given below.
- Moreover, Drag the formula down from G5 to G10.
- As a result, the output will be like the picture below.
Read More: How to Add and Subtract Time in Excel (3 Suitable Examples)
Things to Remember
- If you get the result in an integer form, simply change the number format from General to Date format to show the date.
- You can also customize the format from the custom option in the Number Formatting.
Conclusion
In this article, I have tried to show how to Add and Subtract Dates in Excel with 4 suitable methods. Hope these methods will enhance your excel skill. If you have any queries, let me know in the comment section. Moreover, don’t forget to show your feedback also.
