3

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?

5

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)))

increment dates by exactly one month from a given date

Functions used:

2
  • This looks great, and I think works exactly as I wan it to. I think it also helped me with another question I was going to have. Thank you so much. – Eabryt Jan 30 '20 at 12:49
  • Glad it worked out. SEQUENCE is a very nice, lately introduced function. – marikamitsos Jan 30 '20 at 22:10
0

enter image description here 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.