How to Calculate a Future Date in Excel

1. Open a new or existing Excel workbook and select a new worksheet.
2. Use row 1 for column labels. Type 'Start Date' into cell A1--column A, row 1. Type 'Plus 30 Days' into cell B1, 'Plus 60 Days' into cell C1 and 'Plus 90 Days' into cell D1. To display these column labels correctly, you need to widen columns A, B, C and D. To widen a column, select its right border and then drag it to the right.
3. Select--highlight--cells A2 through D3. Under the 'Home' tab, select the 'Cells' grouping, click 'Format' and then click 'Format Cells' to display the 'Format Cells' window. Click 'Date,' select 'March 14, 2001' and then click 'OK' to format the cells and close the window.
4. In cell A2, type '1/27/15' to display 'January 27, 2015.' Widen column A if you see only pound signs--#######.
5. Type formula '=A2 30' into cell B2 and then press 'Enter' to display 'February 26, 2015,' which is the date in cell A2 plus 30 days. Copy cell B2 and paste it into cells C2 and D2 to display 'March 28, 2015' and 'April 27, 2015.'
6. Type formula '=A2 7' into cell A3 and then press 'Enter' to display 'February 3, 2015.' Copy cells B2 through D2 and paste them into cells B3 through D3 to display 'March 5, 2015,' 'April 4, 2015' and 'May 4, 2015.'
7. Copy row 3 and paste it into row 4 to display 'February 10, 2015,' 'March 12, 2015,' 'April 11, 2015' and 'May 11, 2015.'