Puzzle: Splitting data in to Quarterly Buckets

[reflex_nl]

Howdy!

I have a question: my weekly dataset has to be split over 3 columns; the first 13 weeks in column Quarter, de next 13 in Quarter+1 and the next in Quarter+2, the following 13 has to end-up in column Quarter. So Q1'14 = Quarter, Q2'14 = Quarter +1, Q3'14 in Quarter+2, and Q4'14 in Quarter; Q1'15 in Quarter+1, Q2'15 in Quarter+2, Q3'15 in Quarter etc.....

I would like to add a formula in columns: Quarter, Quarter +1, Quarter +2; which can be dragged down all the way to row 1000+. I tried multiple ways.... but no luck. Any experts here?

Many thanks!!!

BTW: the reason for the split as such is defined by the input of my statisitc program.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Number[/TD]
[TD]Quarter[/TD]
[TD]Quarter+1[/TD]
[TD]Quarter+2[/TD]
[/TR]
[TR]
[TD]1-1-2014[/TD]
[TD]12[/TD]
[TD]..[/TD]
[TD]..[/TD]
[TD]..[/TD]
[/TR]
[TR]
[TD]7-1-2014[/TD]
[TD]8[/TD]
[TD]..[/TD]
[TD]..[/TD]
[TD]..[/TD]
[/TR]
[TR]
[TD]14-1-2014[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AFPathfinder]

I'm not sure I 100% understand what you're wanting to show up in those quarter columns, but I think it would be a combination of functions MONTH and IF:

Cell C2: =IF(MONTH(A1)<4,"First Quarter","")
Cell D2: =IF(AND(MONTH(A1)>3,MONTH(A1)<7,"Second Quarter","")
Cell E2: =IF(AND(MONTH(A1)>6,MONTH(A1)<10,"Third Quarter","")
Cell F2: =IF(MONTH(A1)>9,"Fourth Quarter,"")