Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Add and Subtract Dates in Excel (4 Easy Methods)

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.

Dataset of how to add and subtract dates in excel


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.

Use of Generic Formula to add and subtract dates in excel

  • Enter the following formula in cell E5. 
=C5+D5

Use of Generic Formula to add and subtract dates in excel

  • After that, Press the Enter.
  • Then, Fill Handle the formula from E5 to E10.

Use of Generic Formula to add and subtract dates in excel

  • At last, you will find the result just like the picture given below.

Use of Generic Formula to add and subtract dates in excel

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.

Apply EDATE Function to Add and Subtract Months from Dates

  • Then, Write down the following formula in the selected cell.
=EDATE(C5, D5)
  • After that, Press the Enter.

Apply EDATE Function to Add and Subtract Months from Dates

  • Then, you will find the result like the picture given below.
  • After that, Fill Handle the formula from E5 to E10.

Apply EDATE Function to Add and Subtract Months from Dates

  • As a result, you will find the output like the image given below.

Apply EDATE Function to Add and Subtract Months from Dates

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.

Add and Subtract Years From Dates

  • Write down the formula given below.
=DATE(YEAR(C5)+D5,MONTH(C5),DAY(C5))
  • After that, Press Enter.

Add and Subtract Years From Dates

  • you will find the output in the selected cell just like the picture given below.
  • Moreover, Fill-Handle the formula from E5 to E10

Add and Subtract Years From Dates

  • 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.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo