In this example, the date in cell "A1" will increment by one month. Add dollar signs to the cell reference to keep the reference from changing if you copy the formula.

Type an apostrophe before entering or pasting two numbers separated by a hyphen in Microsoft Excel to keep the numbers from being converted to their month and date equivalent.