How to Create a Formula to Increase a Date by 1 Month

Table of contents:

How to Create a Formula to Increase a Date by 1 Month
How to Create a Formula to Increase a Date by 1 Month

Video: How to Create a Formula to Increase a Date by 1 Month

Video: How to Create a Formula to Increase a Date by 1 Month
Video: How to convert an Excel document into Word document| How to copy table from excel to Word 2024, March
Anonim

Microsoft Excel is a powerful program. If you use it to create a calendar, or anything else where you might need to find the date exactly 1, 2, or 3 months ahead, here's a formula you can use.

Steps

Create a Formula to Increase a Date by 1 Month Step 1
Create a Formula to Increase a Date by 1 Month Step 1

Step 1. Turn on your computer and open an Excel spreadsheet

Create a Formula to Increase a Date by 1 Month Step 2
Create a Formula to Increase a Date by 1 Month Step 2

Step 2. In any cell, for this example we will use cell A2, enter your date

Ex: 1/1/2006.

Create a Formula to Increase a Date by 1 Month Step 3
Create a Formula to Increase a Date by 1 Month Step 3

Step 3. In a different cell, for this example, we use cell B2, enter the amount of months by which A2 will be incremented

Ex: 5.

Create a Formula to Increase a Date by 1 Month Step 4
Create a Formula to Increase a Date by 1 Month Step 4

Step 4. In the last cell, type the formula:

=DATE(YEAR(A2), MONTH(A2)+B2, MIN(DAY(A2), DAY(DATE(YEAR(A2), MONTH(A2)+B2+1, 0))))) replacing A2 and B2 with corresponding cells of your spreadsheet.

Create a Formula to Increase a Date by 1 Month Step 5
Create a Formula to Increase a Date by 1 Month Step 5

Step 5. You will see that this cell will now have the desired calculation

Create a Formula to Increase a Date by 1 Month Step 6
Create a Formula to Increase a Date by 1 Month Step 6

Step 6. Another option is to use =EDATE(start_date, months)

This is a simpler method, but it can only be used if the Analysis ToolPak is installed.

Recommended: