How to add a calendar month to a date? 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 &quot;cell above plus one&quot;. 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 &quot;cell above plus 30,&quot; 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 &quot;7/11/20&quot; I'd like to be able to drag the cell border down to automatically fill the next cell with &quot;7/12/20&quot;.
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)

FINAL RESULT WILL BE: