In Excel, you can add a number of months to a date[1]using the EDATE function. This can be very useful when performingfinancial modelingand you are adjusting time periods. This is a step by step guide on how to have Excel Add Months to Date. For example, if you want to have a mon...
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 ...
EDATE 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.Num_of_months: The number of months you want to add in start date....
In your selected cell, you'll see the date that occurs after adding your specified number of months. If you see a string of numbers instead of the resulting date, that means your cell isn'tusing the date format. To fix that, in Excel's ribbon at the top, click the "Home" tab. Th...
Enter he number of months to add. Click OK. The Output Box will open, displaying the correct result. Read More: How to Add 30 Days to a Date in Excel Download Practice Workbook Add 3 Months to a Date.xlsm Related Articles How Do I Add 7 Days to a Date in Excel How to Add Days...
In Excel’sEDATEperform, you specify the date (source date) to which you’d like to need to add months and the number of months to add. Excel then calculates the resulting date and displays it in your chosen cell. To subtract months from a date, enter a negative month number. As an ...
Also read:How to Add Week to Date in Excel? Add Years to a Date 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 ...
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. ...
Open your Excel spreadsheet. Select a cell. In the formula bar, type yourEDATEformula (eg.=EDATE(“01/01/2022”,1)or=EDATE(A1,1)). Press theEnterkey to return the result. If you used the correct syntax, yourEDATEformula should return a date value that is a number of months ahead ...
Add number of months to date or subtract months from date To add a number of months to or subtract months from dates, theAdd monthsto date also can help you. 1. Select a cell where you want to put the result, for instance, I click cell B2, and then clickKutools>Formula...