Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel