Excel: Count days date range within 12 date ranges


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.

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


This question generated 28 answers. To proceed to the answers, click here.

This thread is current as of June 21, 2014.


For more resources for Microsoft Excel