I have a formula below that checks if a word in Column G matches a word in Cell I (I12 for this example)
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:
For Week 2:
If Cell Q9 = TRUE (Meaning count the first week) and Column C date is within week 2 then:
For Week 3:
If Cell Q9 = TRUE (Meaning count the first week) and Column C date is within week 3 then:
For Week 4:
If Cell Q9 = TRUE (Meaning count the first week) and Column C date is within week 4 then:
-
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:
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:
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:
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:
Bookmarks