How to Add 3 Months to a Date in Excel (4 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel provides time management services in a very efficient way. In addition, You can manage your daily, monthly, or yearly schedule easily using Excel functions & features. For instance, you can add or subtract months from a date for your own calendar. With this in mind, letâ€™s dive into learning 4 easy methods to add particularly 3 months to a date in Excel.

In this part, we will show you 4 easy ways to add 3 months to a date in Excel. For instance, we take a dataset that represents a free Spotify premium subscription, column B consisting of the subscription date. And, column C refers to the expiring dates of the subscription. Meanwhile, for this purpose of demonstration, I used Microsoft Excel 365. However, you can use any other version that is more convenient for you. On this occasion, I used the sample dataset listed below.

1. Insert EDATE Function to Add 3 Months in Excel

The EDATE function gives out the serial number for the date which is the specified number of months before or after the start date. Seeing that, to customize your schedules, use the EDATE function. First of all, we need to categorize the columns in Date format. Follow these next procedures.

Steps:

• First, select columns B & C.

• After that, jump up to the HomeÂ tab.
• In the Home tab, tap the Dropdown box.

• Now, click Date.
• Choose any Date format as you wish.
• Then, hit OK.

After formatting the date in your desired format,

• Go to cell D5.
• Now, you can input the EDATE formula.
`=EDATE(C5,D5)`
• Lastly, press Enter.

As soon as you get the result,

• Copy it all the way down.
• Here is your obtained result.

2. Adjoin Months to a Date Through Excel Date Functions

Excel has some Date functions that we can combine to perform the task. Here, the DATE function takes numeric values in its arguments and gives out a date. 3 arguments pop up when you want to execute Date functions. In the shown figure, you can see the arguments came out as year, month, and day. The YEAR function, on the other hand, returns the year in a 4-digit number. Similarly,Â  the DAY function gives out the day from a cell reference whereas the MONTH function returns the precise month number. As we want to add 3 months to the date, we add 3 with the month parameter. Therefore, follow the steps below.

Steps:

• First of all, input code.
`=DATE(YEAR(B5),MONTH(B5)+3,DAY(B5))`

• As a result, the output will show up.
• Finally, copy cell D as such.

3. Add 3 Months to a Date with Fill Series Feature

The Fill Series Feature lets you fill in your input as per the sequence of the previous data. It is a popular feature that can be used to add months too. Here is how it works,

Steps:

• Select the range D5:D9.

• Navigate through Home > Editing > Fill > Series.

• As a result, Dropbox will pop up.
• Now, check Columns > Date > Month.
• After that, fill up the Step value box.
• Next, hit OK.

• Therefore, the Fill Series Function will autofill the results.

ReadÂ  More: How to Add 6 Months to a Date in Excel

4. Embed VBA Code for Adding Months to a Date in Excel

In our last method, we will try to embed Excel VBA code for adding months in Excel. In this case, VBA will use the DateADD function to update the date. Here, we have the given dataset that we need to update. Coupled with other methods, we will add 3 months to this date.

Steps:

• First, tap Alt+F11 to open the VBAÂ window.
• After that, press Insert and then click Module.
• As a result, a module box will pop up.

• Next, type the following code.
``````Sub AddMonths()
Dim StartDate As Date
Dim mNumber As Integer
Dim Message As String
StartDate = InputBox("Insert the Starting Date")
mNumber = InputBox("Insert Number of Adding Months")
MsgBox Message
End Sub``````
• Also, you can Copy & Paste the code into your Module.
• At last, Run the code.

• Now, an Input Box will pop up.
• Here, type your input date and OKÂ it.

• Similarly, Input the digit of adding months.
• Then, press OK.

• Finally, the Output Box will show up.
• Hence, you obtain your result.

Read More: How to Add 30 Days to a Date in Excel

Conclusion

In conclusion, we have discussed here some easy ways to add 3 months to a date in Excel. Hopefully, you can create your own work schedule, reminder dates, or custom calendar now in Excel. Please feel free to leave any further queries or recommendations in the comment box below.

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Yousuf Khan

Hello! This is MD Yousuf Khan. I am a graduate & post-graduate in Information Technology from Jahangirnagar University, Bangladesh. Currently, I am writing articles for ExcelDemy. I am an independent, self-motivated person with enthusiasm to learn new things, and always try to do my best in any work assigned to me.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF