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.

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

## Related Articles

#### 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