Auto Fill Dates

[amberdk]

How can I "drag" down dates formatted as below to auto update?

[TABLE="width: 500"]
<tbody>[TR]
[TD]November 2016[/TD]
[/TR]
[TR]
[TD]December 2016[/TD]
[/TR]
[TR]
[TD]January 2017[/TD]
[/TR]
[TR]
[TD]February 20217[/TD]
[/TR]
[TR]
[TD]March 2017[/TD]
[/TR]
[TR]
[TD]April 2017[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Enter the first two entries as actual dates, i.e. the first of the month:

11/1/2016
12/1/2016

Then select those two cells and drag down as far as you want.

Then change the Custom Format of the column to "mmmm yyyy".