- Hot Topics
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. 1 2 3 4 5 6 7 8 9 10 11 12 13
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:
This article includes the following tags:
- Microsoft Excel