in this tutorial, it introduces formulas to add months to a given date in Excel, and explains how the formulas work. Formula 1Generic formula:DATE(YEAR(date),MONTH(date))+months,DAY(date))) ArgumentsDate: the date you want to add months to. Months: a whole number which represents the ...
start_date:This must be a valid date representing the start date. It has to be in a valid Excel serial number format. Months:This argument denotes the number of months, either in the past or in the future, from the start date, based on whether it has a positive or negative value. Ho...
Add months Formula using EDATE function in ExcelEDATE function in excel returns the serial number of the date after adding the number of months to a given date.Formula syntax=EDATE(start_date,num_of_months)Start_date: the date in which you want to add months....
Step 2:Use the =EDATE(C3,C5) formula to add the number of specified months to the start date. Where cell C3 is equal to today’s date [the TODAY() function] and cell C5 is equal to the number 3. Step 3:Make sure the output cell is formatted as a Date, and not as a general ...
Apart from adding months to a date, you can also use the EDATE function to add years. Suppose you have a dataset as shown below where you want to add the number of years in column B to the dates in column A Below is the formula that will do this: ...
Use theFill Handleto copy the formula to the cells below. Here is the result: Read More:How to Add Months to a Date in Excel Method 2 – Using Excel Date Functions We can combine some ExcelDatefunctions to perform the task. Here,the DATE functiontakes numeric values in its arguments and...
Example 5 –Run a VBA Code to Add Months to the Date Add 3 months to 5/2/202: Steps: PressAlt + F11to open theVBA window. ClickInsert > Module. Enter the following code: Sub AddMonths() Dim StartDate As Date Dim AddingMonths As String Dim mNumber As Integer Dim Message As String...
A formula using the EDATE function has two mandatory criteria—a date and the number of months to add or subtract. For example,=EDATE(“01/01/2022”,1)would return the date01/02/2022(DD/MM/YYYY) by adding one month to the start date. ...
Here are a few Excel DATE formula examples: =DATE(2015, 5, 20)- returns a serial number corresponding to 20-May-2015. =DATE(YEAR(TODAY()), MONTH(TODAY()), 1)- returns the first day of the current year and month. =DATE(2015, 5, 20)-5- subtracts 5 days from May 20, 2015. ...
= EDATE(date, number of months) 1. Select the blank cell you will place the calculating result, type the formula =EDATE(A2,3), and drag this formula cell’s AutoFill handle to apply this formula to other cells as you need. Note: To subtracting 3 months from the date, please us...