Download Article
Use an Excel date formula to add a month
Download Article
If you're using Microsoft Excel as a calendar or tracker, you don't need to manually change the dates each month or year! You can use the "EDATE" formula to automatically add one month to your existing data. Here's how to create a formula to increase a date by 1 month in Microsoft Excel.
Adding Months to a Date in Excel
To increase the date of a cell by a month in Microsoft Excel, create a new column next to your dates. Select a cell in the new column and type the formula =EDATE(A2,1) where A2 is the first cell of your data and 1 is the number of months to be added.
Steps
-
Insert a new column next to your data. This column is where you'll see the new dates for your data.
- If you don't already have your spreadsheet open, do it now.
-
Format the column. Make sure the column is properly formatted. To do so:
- Select the column you want to format.
- Right-click and select Format Cells .
- Click Date and select a type.
- Click OK .
Advertisement -
Select the first blank cell of your new column. This should be directly next to the first cell of your data.
- For example, the first cell of your data can be A2 while the first cell of your new column can be B2 .
-
Type the formula =EDATE(A2,1) . A2 represents the first cell of your data while 1 represents the number of months to be added to the date. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
- If your first cell has a different location, replace A2 with the location.
-
Press ↵ Enter . This will apply the formula to cell B2. You should see the changed date with one month added.
-
Double-click the square in the changed cell. You may need to select cell B2 again to see it.
- This will apply the formula to the rest of the cells below. The existing date in the cells will all increase by one month.
- If needed, you can delete the original column.
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Video
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
About This Article
Thanks to all authors for creating a page that has been read 340,419 times.
Advertisement