Quick Tip: Add Months to Date in Excel

If you are looking for a simple way to customize your documents in Excel, it is only fitting that you look for information about it. You should investigate how to add months to date in Excel if you need to use it. Giving months to date to your Excel document, you will have order in the data you fill out annually at work.

However, for you to add months to date in excel online, it is good that you know three simple methods. This way, you will know how to modify your Excel document without problems and stand out as a professional.

How to add months to date in excel with EDATE?

To add months to date in excel Mac or on your Windows computer, you can do the following:

1. Open the Excel document where you want to make the changes.

2. Now select the cell where the months to date will be. In this case, cell D4 would be used. Enter the following formula =EDATE(C4, D4) and click the Enter key.

3. You must copy the formula to cell D11 to have the dates in order and save the changes.

How to add months to date in Excel with the MONTH and date function?

You can also apply another method of how to add months to date in excel 2019 or in the version you have on your computer using the MONTH function. This time you must do the following:

1. Open the Excel document and select the cell where you will add the date by a month. In this example, cell D4 was used.

2. Next you must use the formula =DATE(YEAR(C4),MONTH(C4)+D4,DAY(C4)). This formula could vary depending on how many cells you use and where the cells are located.

3. After using the formula in the respective cell, you must copy it to the cells below.

How to increase the date by month in Excel using the fill series option?

Now that you learned how to add months to date in excel 2016, you could try to investigate the increase of the date by a month. This way, you will be able to have an even more personalized document that your employers will like. To add months to date in excel with increases in days, you must do the following:

1. Open the Excel document again and click on the cell where you want to start, increasing the date by a month. In the example, cell C4 through cell C11 were used.

2. Now, go to the home tab, then to edition, and click on fill.

3. Press the series option

4. Then, a dedicated box for series will open where you must modify the columns, date, and month to your liking. When you have finished with the changes, click on ok.

5. Now, you must check that all the dates were placed in the respective cells.

Knowing how to add months to date in excel will be very helpful in the workplace, so you should not ignore these methods. On the contrary, you should look for more information about it to become an expert using Excel. On the internet, you will come across many more informative guides on the subject; you have to take advantage of them starting today.

If you are looking for the ideal website to know how to add months to date in Excel, you may be surprised to see more guides of the exact nature. On the other hand, these websites will allow you to download WPS Office without investing a single penny.