Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles DATE AND TIME Add months to date

Add months to date

While working with excel spreadsheets, we might need to add months to date. To do this, we can use the EDATE function as explained in this post.

Figure 1: Adding months to date using EDATE function

General syntax of the formula

=EDATE (date, months)

Understanding how the formula works

Working with this formula is pretty simple. There are very few steps required for you to work with this function and add months to date.

  • The function is automatic
  • It returns a new date when supplied with a valid date and number of months.
  • If you want to subtract months from the given date, then you need to supply a negative value.

While it is recommended to use cell reference, you can also put the number of months directly into the EDATE function.

Things to remember

While working with the EDATE function, you need to format the cells to get the date in your preferred date format.

Example

Figure 2: Using EDATE function to add months to date

In this example, to get the new dates, we need to add the months in column B to the current date in column A.

We then put our formula in cell C2, to get the new date for row 2. We do this by putting our formula in the cell, i.e. =EDATE (A2,B2) and pressing Enter.

To get the new dates for the other cells, we simply copy the formula across the other cells in column C.

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc