Counting Days within multiple date ranges

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results, mock them up manually. Highlight those cells you're trying to automate.

Use BEFORE/AFTER sheets if that helps make it clearer.

Thank you... see uploaded Excel sheet (both pages)

Example: Reservation 1 (line 4) - count the number of reservation days IF 8/11/11-8/14/11 falls within the billing dates in column D, E, F, G, or H. The answer should only show up in column E as 3 (days).

Put this in D4 and copy down and across the table:

=MEDIAN(D$2,D$3,$C4)-MEDIAN(D$2,D$3,$B4)

You can go into the File > Options > Advanced > Sheet options and turn off the display of zero values on that sheet if you wish. I usually don't.

You'll need to re-enter that date in B9, it's not a real date value.

I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.