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.

add 3 months to a date in excel


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.

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

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 Add Years to a Date in Excel


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


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.

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


Download Practice Workbook

You can download this workbook to practice yourself.


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.


Related Articles


<< Go Back to Adding Days to Date | Calculate Dates | Date-Time in Excel | Learn Excel

What is ExcelDemy?

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

Yousuf Khan has been working with the ExcelDemy project for over one year. He has written 47+ articles for the ExcelDemy site. He also solved a lot of user problems with ExcelDemy Forum. He has interests in Excel & VBA, Desktop and mobile applications, and projects & templates. He completed his graduation and post-graduation in Information Technology from Jahangirnagar University. Currently, he works as a VBA & Excel Content Developer in ExcelDemy projects, writing unique and informative content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo