Is it possible to make a list of months?

Question

excel

Is it possible to set in Excel somewhere in the cell "07.2015" and it will automatically arrange horizontally "07.2015", "08.2015" ..... and so on?

Answer 1

Attention! Explanation and example are given for English excel and regional format with ";" delimiter. If you have a Russian Excel, you will need to use the Russian analogues of the above formula, the Russian analogue of the custom date format and the Russian function argument separator (EMNIP, comma instead of semicolon). If there are problems - write in the comment, we'll figure it out.
Enter, for example, the date "07/01/2015" in cell A1.
In the cell on the right - B1 - enter the formula
and drag it to the right as needed.
Now select this entire range, press Ctrl + 1 to go to the cell format, select "Custom" on the left, write "mm.yyyy" in the Type on the right
Nuance: although the dates will be visually displayed as "two digits of the month - a dot - four digits of the year", in fact, each cell will contain the date of the first day of each month, this must be taken into account if the cells are used not only as headers, but also as data for which any calculations.