Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

Open your spreadsheet in Microsoft Excel and locate the date you wish to increment. Click and drag your mouse from the cell containing the date to the last cell in the range.