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.

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.