# How to Add Months to a Date in Excel (2 Ways)

In Excel when you have to adjust the periods of time, you can add months or years to date using some specific functions. This is quite important when you are performing financial modeling or other date-based assignments. Today in this article, we will learn how to add months to a date in Excel.

Quick View

Here is a quick view of our todayâ€™s task.

## Add Months to a Date in Excel (2 Ways)

Consider a situation where you want to know the date after a specific number of months. Excel has two in-built functions that can help you in this situation. Letâ€™s learn those methods.

### 1. Using The EDATE Function

The Excel EDATEÂ function will give you the exact date if you add months to a specific date. Using this function, you can add or subtract months from the given date.

#### i. Adding Months to a Date

Step-1:

Let us assume that we are given some dates and some number of months. We have to find the final date after adding those months to those specific dates. To do this, create a table containing columns â€śStart Dateâ€ť, â€śMonthsâ€ť, and â€śFinal Dateâ€ť. First, we need to set the format of the â€śStart Dateâ€ť and â€śFinal Dateâ€ť columns. Now go to â€śHomeâ€ť, in the â€śNumberâ€ť ribbon, click on this iconÂ  to open different formats. Select â€śMore Number Formatsâ€ť to continue.

Homeâ†’ Number Ribbonâ†’ Number Formatâ†’ More Number Formats

A new window popped out. Now in the â€śCategoryâ€ť, select â€śDateâ€ť and in â€śTypeâ€ť, choose the date format you like.

Step-2:

Now add those dates and months that you are given to the â€śStart Dateâ€ť and â€śMonthsâ€ť columns.

Step-3:

In the cell â€śD4â€ť of the â€śFinal Dateâ€ť column, apply the â€śEDATEâ€ť function. The generic EDATE function is

=EDATE(start_date, months)

Insert the values into the function and the final formula is

=EDATE(B4,C4)

Where,

• Start_date is B4
• Months is C4

Press â€śEnterâ€ť to get the result.

Step-4:

Now move the mouse cursor to the lower right corner of the D4 cell and when the cross icon (+) is shown, double click on this to apply the same function to the rest of the cells.

Step-5:

Now here is an interesting thought! If you input the month value in fraction format the â€śEDATEâ€ť function will only count the integer part. That means the function will ignore the value after the decimal point. Thatâ€™s why the function only considered â€ś5â€ť in those red marked boxes.

#### ii. Subtract Months from a Date

Now we will subtract months from the given dates using the same â€śEDATEâ€ť function.

Step-1:

In the following example, we are given this data table where the monthâ€™s values are negative.

Step-2:

Now in the D4 column, apply the same â€śEDATEâ€ť function that you used in the previous example.

Press â€śEnterâ€ť to get the result.

Step-3:

The values after the decimal point are also ignored here.

### 2. Using the DATE function

We can add months to date easily by using the â€śDATEâ€ť function. Letâ€™s see how.

Step-1:

In the following example, we are given some dates and months in the â€śStart Dateâ€ť column and â€śMonthsâ€ť column. We need to add these months to these dates in the â€śFinal Dateâ€ť column.

Step-2:

In the cell â€śD4â€ť apply the â€śDATEâ€ť function. The generic â€śDATEâ€ť function is

=DATE(year,month,day)

Now insert values into the â€śDATEâ€ť function and the final formula is,

=DATE(YEAR(B4),MONTH(B4)+C4,DAY(B4))

Where,

• The YEAR function looks at the date in cell B4 and returns 2017.
• The MONTH function returns the month value from cell B4. It then adds 2 months from cell
• The DAY function returns the day value from cell B4.

Now get the result by pressing â€śEnterâ€ť. We have got our required date.

Step-3:

Now apply the same formula for the rest of the cells.

Step-5:

The â€śDATEâ€ť function can also subtract months from a date. Look at the result in cell D12.

## Quick Notes

đź‘‰ Change the format of the cells using the â€śDatesâ€ť option in the number ribbon.

đź‘‰The â€śEDATEâ€ť function will return #VALUE! error if the start date is an invalid date.

đź‘‰If the â€śMonthsâ€ť is not an integer, then the integer value before the decimal point is considered.

## Conclusion

How to add months to a date in excel is discussed here in this article. We hope that you will find a solution to your problem in this article. If you have any thoughts or confusion regarding this article, you are welcome to comment.