Creating a Group Series

[nytwodees]

My 1st column contains the following rows:

January 31, 2016
January 31, 2016
January 31, 2016
January 31, 2016
...GRAND TOTAL:

Consider this data as a Group of 5 rows.

I would like to create a series that increase the subsequent group of 5 rows and other groups that follow by 1 month increments. The 1st column should look something like this:

January 31, 2016
January 31, 2016
January 31, 2016
January 31, 2016
...GRAND TOTAL:
February 29, 2016
February 29, 2016
February 29, 2016
February 29, 2016
...GRAND TOTAL:
March 31, 2016
March 31, 2016
March 31, 2016
March 31, 2016
...GRAND TOTAL:

and so on

Is there any simple way to create an incremented group series such as I've shown?

Any help will be appreciated!

Thanks,

Dan

[Pete_UK]

Are those dates proper dates, or text values?

If they are proper dates, then you can use this formula in A6:

=IF(ISNUMBER(A1),EOMONTH(A1,1),A1)

(assuming the dates start in A1). Format that cell as a date in the style you prefer, and then copy the formula down as far as you need to.

Hope this helps.

Pete

[EchoPassenger]

Nevermind, beaten to it!

[sanram]

Enter the start date on A1. The write the below formula on A2 :

Please Login or Register  to view this content.

Now copy down. That's it. See the attachment.

[nytwodees]

Thanks Pete! Worked perfectly.

Dan