Is there a way to lookup/find the amount of the last day of a 7 consecutive week? Ie.. Week 9 (starts on Friday and ends on Thursday) and Week 12 (starts on Monday and ends on Sunday) both have 7 consecutive days. I am trying to figure out a formula that would be able to return 8. I already created another column that counts the 7 consecutive days and am unsure if another IF or any other formula statements can be used to find/lookup the 8 amount.
| Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | |
| Week 1 | 10 | 9 | 12 | 3 | |||
| Week 2 | 4 | 2 | 13 | 8 | |||
| Week 3 | 10 | 10 | 10 | ||||
| Week 4 | 10 | 10 | 10 | ||||
| Week 5 | 12 | 10 | 12 | 12 | 12 | ||
| Week 6 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Week 7 | 12 | 12 | 12 | 12 | |||
| Week 8 | 12 | 12 | 12 | 12 | 12 | ||
| Week 9 | 12 | 12 | 12 | 8 | 12 | 12 | 12 |
| Week 10 | 12 | 12 | 12 | 12 | |||
| Week 11 | 12 | 12 | 12 | 12 | 12 | 8 | |
| Week 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 |
| Week 13 | 12 | 12 | 12 | 12 | |||
| Week 14 | 12 | 12 | 12 | 12 | |||
| Week 15 | 12 | 12 | 12 | ||||
| Week 16 | 12 | 12 | 12 |
