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?

2 Answers 2

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, 2020 at 12:49
  • Glad it worked out. SEQUENCE is a very nice, lately introduced function. Jan 30, 2020 at 22:10
1

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 and acknowledge that you have read and understand our privacy policy and code of conduct.

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