Google Sheets Increase month by 1 but leave everything else the same

I am using Google Sheets and have 700+ rows that have an assortment of dates but the month is the same on all of them (monthly billing cycle)

each month I am having to manually go through each line and re-type the correct date… this take a long time.

Is there a way I can just select all the rows in one column and increase the month of each date by 1?

snippet of my sheet each month I have to change only the month and leave day and year the same

Answer

Use EDATE function

Set the first value in the cell to a specific date. Like 1/1/2020

Second cell set this formula:

=EDATE(FirstDate,1)

Drag the value above to other cells.

Attribution
Source : Link , Question Author : Carl , Answer Author : Prabhu P

Leave a Comment