Extend current formula for a date range

I have a formula below that checks if a word in Column G matches a word in Cell I (I12 for this example)

Please Login or Register  to view this content.

In Column C I have a row of dates (associated with the same rows as the words that can appear like so:

10/1/2013
10/1/2013
10/1/2013
10/2/2013
10/3/2013
10/4/2013
10/4/2013
10/4/2013
10/4/2013
10/7/2013
10/8/2013

I only count words for 4 weeks out of the month so I also have a Boolean TRUE/FALSE formula on Cell Q9 that will say:

Yes (Count the first 4 weeks of the month)
or
No (Count the 4 weeks skipping the first week of the month)

1st of Current Month:	10/1/2013
First Day of Month:	2
Days in Week:	7
Count First Week?	TRUE

How can I extend my formula to count as so if Q9 is TRUE:

---

For Week 1:
If Cell Q9 = TRUE (Meaning count the first week) and Column C date is within week 1 then:

Please Login or Register  to view this content.

For Week 2:
If Cell Q9 = TRUE (Meaning count the first week) and Column C date is within week 2 then:

Please Login or Register  to view this content.

For Week 3:
If Cell Q9 = TRUE (Meaning count the first week) and Column C date is within week 3 then:

Please Login or Register  to view this content.

For Week 4:
If Cell Q9 = TRUE (Meaning count the first week) and Column C date is within week 4 then:

Please Login or Register  to view this content.

---

-
or if Q9 is false
-


For Week 1:
If Cell Q9 = FALSE (Meaning count starting the second week of the month) and Column C date is within week 2 then:

Please Login or Register  to view this content.

For Week 2:
If Cell Q9 = FALSE (Meaning count starting the second week of the month) and Column C date is within week 3 then:

Please Login or Register  to view this content.

For Week 3:
If Cell Q9 = FALSE (Meaning count starting the second week of the month) and Column C date is within week 4 then:

Please Login or Register  to view this content.

For Week 4:
If Cell Q9 = FALSE (Meaning count starting the second week of the month) and Column C date is within week 5 then:

Please Login or Register  to view this content.

Well after piecing together internet codes I think I've put together the below code. If anyone see's any issues with it please let me know but i'm still trying to incorporate it to use the Boolean YES/NO to determine if the first week of the month should be counted as week one or if the 4 weeks after the is 4 weeks should be counted.

Please Login or Register  to view this content.