Friday, May 25, 2012

How to Use the Date Function in Excel to Show Next Month


1. Open Excel 2007 and type '2010' in cell A1. Enter '10' in cell A2 and '11' in cell A3. This information will be used as reference data in the Date function. Enter the Date function '=Date(A1,A2,A3)' in cell B1. This function will display a numerical representation of the date 10/11/2010.
2. Format how the date displays by right-clicking cell B1 and selecting 'Format Cells.' Click the Number tab and pick the 'Date' category. Select a date format. Click 'OK.'
3. Change the formula in cell B1 to add 30 days to the current day to display the next month. Enter the following formula: '=DATE(A1,A2,A3 30).' The cell will reflect the date of 11/10/2010.

Blogger news