Microsoft Excel is a powerful program. If you are using it for a calendar or anything else where you might need to find the date exactly 1, 2, or 3 months after another date here is a formula you can use. Steps. Turn on your computer and open a new or existing Excel spreadsheet. In any cell, for this example we will use A2, type in you date. In a different cell, for this example we used B2, type in the amount of months cell A2 is to be incremented by. =DATE(YEAR(A2),MONTH(A2)+B2,MIN(DAY(A2),DAY(DATE(YEAR(A2),MONTH(A2)+B2+1,0)))) replacing what is in bold with the appropriate cells for your spreadsheet. You will see that this cell now has the calculation desired.
http://www.wikihow.com/Create-a-Formula-to-Increase-a-Date-by-1-Month
1 To insert a date, click on the cell and pick the date from the Calendar. 2  To change a date, click on the cell with a date and pick a new date. 3  Click on the cell with a date and this date gets highlighted in the Calendar.  Flip to previous/next month using navigation arrows.
https://xltools.net/excel-apps/calendar-app/
1 Add the first date in some cell. 2  Select that cell, right-click on the fill handle, drag it down or across several cells, and then release. 3  In the context menu, click Series.  In the Series dialog box, choose the appropriate Date unit and enter the Step value.
https://www.ablebits.com/office-addins-blog/2015/03/18/insert-dates-excel/
Click on the cell with the first date to select it, and then drag the fill handle across or down the cells where you want Excel to add dates. The fill handle is a small green square that appears at the bottom-right corner when you select a cell or a range of cells in Excel, as shown in the screenshot below.
https://www.ablebits.com/office-addins-blog/2015/03/18/insert-dates-excel/
How to insert a date in a cell from the Calendar add-in. 1  To insert a date, click on the cell and pick the date from the Calendar. 2  To change a date, click on the cell with a date and pick a new date.  Click on the cell with a date and this date gets highlighted in the Calendar.
https://xltools.net/excel-apps/calendar-app/
In a different cell, for this example we used B2, type in the amount of months cell A2 is to be incremented by. Ex. 5. 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 what is in bold with the appropriate cells for your spreadsheet.
http://www.wikihow.com/Create-a-Formula-to-Increase-a-Date-by-1-Month
How to add the Calendar for Excel from the Office Store. Download the add-in from the Office Store website, or directly from Excel interface: 1  Open Excel > Insert tab > In the Add-ins group click ‘Store’ or ‘Office Add-ins’.  Search for XLTools Calendar in the Store > It is free, so just click ‘Add’.
https://xltools.net/excel-apps/calendar-app/
Download the add-in from the Office Store website, or directly from Excel interface: 1  Open Excel > Insert tab > In the Add-ins group click ‘Store’ or ‘Office Add-ins’. 2  Search for XLTools Calendar in the Store > It is free, so just click ‘Add’.  The Calendar will appear on the sheet. Drag and place the form as you wish.
https://xltools.net/excel-apps/calendar-app/
Year, Month, Day. To get the year of a date, use the YEAR function. Note: use the MONTH and DAY function to get the month and day of a date. 1. To add a number of days to a date, use the following simple formula. 2. To add a number of years, months and/or days, use the DATE function. Note: the DATE function accepts three arguments: year, month and day. Excel knows that 6 + 2 = 8 = August has 31 days and rolls over to the next month (23 August + 9 days = 1 September).
http://www.excel-easy.com/functions/date-time-functions.html
How to enter a date in Excel. You can type a date in an Excel cell in a variety of ways, for example 1/1/2015, or 1-Jan-2015, or 1-Jan, or January 1, 2015. When you type something like that in a cell, Microsoft Excel knows you are entering a date and automatically applies the date format to that cell.
https://www.ablebits.com/office-addins-blog/2015/03/18/insert-dates-excel/
how to add dates in excel
You can type a date in an Excel cell in a variety of ways, for example 1/1/2015, or 1-Jan-2015, or 1-Jan, or January 1, 2015. When you type something like that in a cell, Microsoft Excel knows you are entering a date and automatically applies the date format to that cell. To add dates in excel, type a date in an Excel cell in a variety of ways, like, 1st January 2015. When you type something like that in a cell, Microsoft Excel knows you are entering a date and automatically applies the date format to that cell.