Add months to a date in Microsoft Excel

Add months to a date in Microsoft Excel

August 6, 2022 By Alessia Hernandez

Ever wonder what the date will be after a certain amount of time has passed? Well, Microsoft Excel has developed an option to make this calculation. If you want to know how to do it, continue reading.

As we know, Excel is the most famous and complete “Spreadsheet” type program and is the preferred choice for everything from the simplest operations to complex accounting formats such as payroll, payment vouchers, mortgage loans, among others. On the other hand, its almost infinite number of cells allows users to make formats with as many fields as they require.

Likewise, it should be highlighted that Excel is not only used to make mathematical calculations as we know them since it gives us the opportunity to calculate dates, times, percentages and even currencies. 

Then, to use the Excel EDATE function properly you just have to specify the starting date and the number of months you want to add to it , so that the tool can easily perform the calculation in the selected cell. Moreover, you can also subtract months from the established date to accomplish this function by entering a negative month number. For example, to remove 5 months from a date, enter -5 (minus five) instead of just 5.

If this explanation has not been enough, please follow these steps to learn how to apply the formula smoothly.

  1. First of all, be sure to open a new spreadsheet from the Excel application installed on your PC or the online version offered by Office.
  2. Now, select one specific cell in which you want to get the result of the calculation.
  3. Afterwards, type the next function in the chosen cell: (=EDATE (C2,C4). Keep in mind you must replace C2 with the cell that contains your source date and C4 with the cell that has the number of months to add.
  4. Remember to subtract months instead of adding them to the calculation, you must put negative numbers (with a minus sign in front of them).
  5. Then, you will see the corresponding date reflected after adding the specified months.
  6. If on the contrary, your result appears as a string of numbers, it means your cell is not using the right format. If this is your case, you can fix it by going to the options bar at the top of Excel. Next, locate the Home tab and go to the Number section. Lastly, click on the drop-down menu and choose the “Short Date” format.

Valentina Tuta


Getting started with Microsoft Sway
Getting started with Microsoft Sway
Get started with Microsoft Sway, an application specially designed for users who enjoy to design and share their creativity through interactive reports, personal stories, presentations and colorful canvases. In this article you will learn how to add or embed content…

Little Devil Inside: Everything we know
Little Devil Inside: Everything we know
Little Devil Inside is a game uncovered by Neostream Interactive back in June 2020 at the PS5 grandstand and we've been enamored with it from that point forward. Its particular interpretation of the extraordinary adventuring life is propelled, lovable and…

Xbox Game Pass August 2022: All new games
Xbox Game Pass August 2022: All new games
Calico and ScourgeBringer will be free for Subscribers of the Live Gold assistance in August. Furthermore, with the assistance of in reverse similarity, Xbox One and Series S/X clients will get two games from the Xbox 360 - Saint's Row…

How to fix upload pending error on Microsoft Word
How to fix upload pending error on Microsoft Word
Microsoft Word's AutoSave highlight is a lifeline, particularly with the OneDrive joining to save all alters progressively to the distributed storage and make the record accessible on each stage. You don't have to stress over Word crashing or running into…

PlayStation: Sony stops technical support via Twitter
PlayStation: Sony stops technical support via Twitter
Whether it was by phone contact, the authority site PlayStation or their social channels, throughout the long term Sony has made specialized help accessible for any issue with its control center, to address the issues of clients through the most…

How to create a Lollipop Chart in Excel
How to create a Lollipop Chart in Excel
Succeed gives various types of diagrams to performing estimations and dissecting them outwardly. We can likewise add some extra modules for doing estimations in the worksheet. Kutools is a strong utility that gives in excess of 300 high level elements.…