How to increment dates by exactly one month from a given date in Google Sheets

Question

I'm using Google Sheets and want to set a date in say E:7, then in Column B I want the first row to be the value E:7 and then all the rows below that to be incremented by exactly one month from the one above. I know I can set B:1 to =E:7 however I can't figure out the best way to implement after that. Simply saying B:1 + 30 doesn't work because not all months have 30 days.

Is there a way to do this?

Answer 1

The formula you can use to increment dates by exactly one month from a given date is:

=ArrayFormula(EDATE(E7,SEQUENCE(14,1,1,1)))

Functions used:

• ArrayFormula
• EDATE
• SEQUENCE

Answer 2

In B1 type your start date. Type in C1 the formula: =EDATE(B1,1) This would also do the trick and then drag it over the range you want and it will auto increment the month.