Hello,
I have a requirement to calculate the closed week in a given quarter. 

- Within every quarter, Week 1 = Days 1-7; Week 2 = Days 8-14, etc. 
- The cycle should start again for every Quarter. So each quarter will have 13 weeks.

The solution I created works but it isn't the most efficient and I was hoping someone with better formula kung fu could help me revise.  Thank you in advance for your help.

IF( 
AND( 
OR( 
MONTH(CloseDate) = 1,MONTH(CloseDate) = 4,MONTH(CloseDate) = 7,MONTH(CloseDate) = 10),90 - DAY(CloseDate) >= 83),"Week 1", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 1,MONTH(CloseDate) = 4,MONTH(CloseDate) = 7,MONTH(CloseDate) = 10),90 - DAY(CloseDate) >= 76),"Week 2", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 1,MONTH(CloseDate) = 4,MONTH(CloseDate) = 7,MONTH(CloseDate) = 10),90 - DAY(CloseDate) >= 69),"Week 3", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 1,MONTH(CloseDate) = 4,MONTH(CloseDate) = 7,MONTH(CloseDate) = 10),90 - DAY(CloseDate) >= 62),"Week 4", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 1,MONTH(CloseDate) = 4,MONTH(CloseDate) = 7,MONTH(CloseDate) = 10),90 - DAY(CloseDate) >= 59),"Week 5", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 2,MONTH(CloseDate) = 5,MONTH(CloseDate) = 8,MONTH(CloseDate) = 11),59 - DAY(CloseDate) >= 53),"Week 6", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 2,MONTH(CloseDate) = 5,MONTH(CloseDate) = 8,MONTH(CloseDate) = 11),59 - DAY(CloseDate) >= 46),"Week 7", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 2,MONTH(CloseDate) = 5,MONTH(CloseDate) = 8,MONTH(CloseDate) = 11),59 - DAY(CloseDate) >= 39),"Week 8", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 2,MONTH(CloseDate) = 5,MONTH(CloseDate) = 8,MONTH(CloseDate) = 11),59 - DAY(CloseDate) >= 32),"Week 9", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 3,MONTH(CloseDate) = 6, MONTH(CloseDate) = 9, MONTH(CloseDate) = 12),31 - DAY(CloseDate) >= 30),"Week 9", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 3,MONTH(CloseDate) = 6, MONTH(CloseDate) = 9, MONTH(CloseDate) = 12),31 - DAY(CloseDate) >= 23),"Week 10", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 3,MONTH(CloseDate) = 6, MONTH(CloseDate) = 9, MONTH(CloseDate) = 12),31 - DAY(CloseDate) >= 17),"Week 11", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 3,MONTH(CloseDate) = 6, MONTH(CloseDate) = 9, MONTH(CloseDate) = 12),31 - DAY(CloseDate) >= 10),"Week 12", 

IF( 
AND( 
OR( 
MONTH(CloseDate) = 3,MONTH(CloseDate) = 6, MONTH(CloseDate) = 9, MONTH(CloseDate) = 12),31 - DAY(CloseDate) >= 3),"Week 13", 

"Week 13"))))))))))))))