Add One Month in Numbers

I read the answers on this post Add one month in Numbers - Apple Community and was not satisfied with the solutions.

The use case is common, for many charts and tables we don't care about the day, only the month. Therefore the date value in our "Month" column will need to be the first of each month. Like the OP requested:

The solution is as follows:

1. Your first cell (A1) contains the initializer date, 3/1/2017 as a static value
2. Add this formula as the next cell below, then copy and past/fill it down:

DATE(YEAR(A1),MONTH(A1)+1,1)

When you paste/fill the formula will adjust as usual, which means you are in actuality moving the date itself one calendar month forward. This means when we get to December and add a month, we will progress to the next year as expected.

Hope this helps folks and happy for any comments/concerns with this approach.