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

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

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.


Download Practice Workbook

You can download this workbook to practice yourself.


4 Easy Methods to Add 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.

add 3 months to a date in excel


1. Insert EDATE Function to Add 3 Months in Excel

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.

Insert EDATE Function to Add 3 Months in Excel

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

  • Now, click Date.
  • And 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.

Read More: How to Add Months to a Date in Excel (2 Ways)


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 adjoin 3 with the month parameter. Therefore, follow the steps below.

Steps:

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

Adjoin Months to a Date Through Excel Date Functions

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

Read More: How to Apply Excel Formula to Count Days from Date to Today


Similar Readings


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.

Add 3 Months to a Date with Fill Series Feature

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

Add 3 Months to a Date with Fill Series Feature

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

Add 3 Months to a Date with Fill Series Feature

Read More: How to Add 6 Months to a Date in Excel (2 Easy Ways)


4. Embed VBA Code for Adding Months 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.

Embed VBA Code for Adding Months in Excel

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 AddingMonths As String
Dim mNumber As Integer
Dim Message As String
AddingMonths = "m"
StartDate = InputBox("Insert the Starting Date")
mNumber = InputBox("Insert Number of Adding Months")
Message = "Updated Date: " & DateAdd(AddingMonths, mNumber, StartDate)
MsgBox Message
End Sub
  • Also, you can Copy & Paste the code into your Module.
  • At last, Run the code.

Embed VBA Code for Adding Months in Excel

  • 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 (7 Quick Methods)


Conclusion

In conclusion, we have discussed here some easy ways to add 3 months to a date in Excel. Not to mention, our ExcelDemy website shows various simple problem-solving methods like this. Please feel free to leave any further queries or recommendations in the comment box below.


Related Articles

Yousuf Khan

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

Leave a reply

ExcelDemy
Logo