dragging dates in a table header row

[stephme55]

I have a table and I have 1/1/2016, 2/1/2016, and I want to drag it across the row (I select both and right click drag) but it's not increasing the months it's just repeating. What to do/

[Amanda Wilso]

Screen Shot 2017-01-20 at 8.15.16 PM.png

Type the beginning date in the cell. For our example, we've entered the first day of the year. Right-click on the Fill Handle and drag down the column.
When the mouse button is released, a menu displays as shown in the first image. We select Months in our example.
Excel autofills the column with the first day of each consecutive month as shown.