How many days of a given date range in C2:D2, fall within multiple date ranges in columns A2:B13?
I'm interested in formulas in column E2:E13 (count per period) and F2 (total count). I typed in the desired results in Green.
Help is much appreciated.
<tbody>
</tbody>
I'm interested in formulas in column E2:E13 (count per period) and F2 (total count). I typed in the desired results in Green.
Help is much appreciated.
A | B | C | D | E | F | |
1 | Start_Of_Month | End_Of_Month | Start | End | Count | Total_Count |
2 | 1-1-2014 | 31-1-2014 | 15-3-2014 | 27-7-2014 | 0 | 133 |
3 | 1-2-2014 | 28-2-2014 | 0 | |||
4 | 1-3-2014 | 31-3-2014 | 16 | |||
5 | 1-4-2014 | 30-4-2014 | 30 | |||
6 | 1-5-2014 | 31-5-2014 | 31 | |||
7 | 1-6-2014 | 30-6-2014 | 30 | |||
8 | 1-7-2014 | 31-7-2014 | 26 | |||
9 | 1-8-2014 | 31-8-2014 | 0 | |||
10 | 1-9-2014 | 30-9-2014 | 0 | |||
11 | 1-10-2014 | 31-10-2014 | 0 | |||
12 | 1-11-2014 | 30-11-2014 | 0 | |||
13 | 1-12-2014 | 31-12-2014 | 0 |
<tbody>
</tbody>