Rolling Month w/ a Twist

[jdotwu]

So I've tutorials online on how to do a rolling month, but I have a unique circumstance in that I need a month to duplicate. For instance

Cell B1 = JANUARY

I need the output to be

JANUARY JANUARY FEBRUARY MARCH APRIL MAY JUNE.....

If I change Cell B1 to April, my output needs to be

JANUARY FEBRUARY MARCH APRIL APRIL MAY JUNE....

I have my January through December in a list already. Any guidance on how I could accomplish this via a formula would be greatly appreciated!

 

[StephenCrump]

It sounds like you have a list of text values "January" ... to "December".

But you'd be better off using dates, i.e. numeric values, as it gives you more flexibility in working with your data.

All values below are dates formatted as "MMMM"

B1: Any date in April
B3: Any date in January (year of your choice)
C3: =EDATE($B3,COLUMNS($B3:B3)-(COLUMNS($B3:B3)=MONTH($B1))) Copy right

Book1
	B	C	D	E	F	G	H	I
1	April
2
3	January	February	March	April	April	May	June	July
Sheet1

This assumes you only need one year's worth of column headers?