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?