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