How to add a calendar month to a date

numbers

In Numbers, if I have a column for dates, and I want each cell to be one day later than the cell above, I can enter a date in the first cell and then set the next cell to be "cell above plus one". Then I can drag the cell border down to fill the column with increasing consecutive dates.

Is it possible to do this with calendar months? A rough approximation would be to set each cell to be "cell above plus 30," but this would give a different date each month. I want to be able to fill cells with the same date each calendar month. In other words, if a cell contains "7/11/20" I'd like to be able to drag the cell border down to automatically fill the next cell with "7/12/20".

Best Answer

You can try formula and get easily what you are looking for.

EDate, starting row and month =1 (which increase the month when you scroll it)

enter image description here

FINAL RESULT WILL BE:

enter image description here