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
Step 1. Turn on your computer and open an Excel spreadsheet
Step 2. In any cell, for this example we will use cell A2, enter your date
Ex: 1/1/2006.
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.
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.
Step 5. You will see that this cell will now have the desired calculation
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.