How to automatically increment periods by one month with different start dates

One way.

Column C =from day. Column D= end date

So in c2 type your start date and in D2 the end date for Apple. In next 2 rows type the info for the 2 others.

Then in C5 put this.

=DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))

Drag to D5 and copy down as you want.

Thanks! But it's not working. Saying if the previous date is 30June, next month will be 30July instead of 31July after using this formula. And also, since I have 3 people in my example, I can't simply drag the formula cells that will be overlapped. I think some conditions should be included, right?

Originally Posted by Fotis1991

One way.

Column C =from day. Column D= end date

So in c2 type your start date and in D2 the end date for Apple. In next 2 rows type the info for the 2 others.

Then in C5 put this.

=DATE(YEAR(C2),MONTH(C2)+1,DAY(C2))

Drag to D5 and copy down as you want.

...Saying if the previous date is 30June, next month will be 30July instead of 31July after using this formula

Formula gives 30 July as result in your example. Not 31 of July.

Am i missing something?

Ok. I see it...

Try

=EDATE(C2,1)

The EDATE function/formula is part of the Excel Analysis Toolpak which must be installed for its use. That is, Tools>Add-ins and check Analysis Toolpak.