Match a date when date ranges sometimes overlap and return multiple results

Hi Experts,

I have encountered a deadlock in the excel sheet which is enclosed for your reference.
I have three sheets
First one is the calendar view (ENV Calendar) which would reflect/highlight the environment booking details based on my second sheet date range i.e. ENV Data.

I've fairly achieved the most of my objective except a major one and i.e. when a date is falling in two date ranges how would my calendar reflect that ?
What i wish to achieve is if I combine those two results as an output like 1-2 or 2-3 or 3-1 i'd go for a conditional formatting creating a separate legend for new outputs but how would i get those ?

I tried using something like this but this didn't help me

=INDEX($B$3:$B$6, SMALL(IF(($C$8>=$C$3:$C$6)*($C$8<=$D$3:$D$6), MATCH(ROW($B$3:$B$6), ROW($B$3:$B$6))), ROW(A1)))
as this would give me outputs in multiple cells and that too depending upon the value given in ROW(A1) at the last of the formula. How could i use this dynamically in a single formula to achieve the desired output as mentioned above?

Robert

Basically i want my calendar to show multiple environments booked on a given date. I have my formulae places in B15:H20 but it just shows one environment even if the dates are overlapped in two or more date ranges (in sheet END Data).

E.G If ENV1 is booked from 1-Jan-2013 till 15-Mar-2013 and at the same time ENV 2 is also booked from 10-JAN-2013 till 20-JAN-2013 and ENV 3 is booked from 18-Jan-2013 then i want my formulas to come up with the output 1-2-3 which am unable to do however for two environments i got it working but for 3 or more environments it doesn't work.

Formula for two environments with output 1-2 or 2-3 or 3-1 is
INDEX(tblEnv[[#All],[Env]],MATCH(1,(C7>=tblEnv[[#All],[From Date]])*(C7<=tblEnv[[#All],[To Date]]),0))&IF(SUMPRODUCT((C7>=tblEnv[[#All],[From Date]])*(C7<=tblEnv[[#All],[To Date]]))>1,","&INDEX(tblEnv[[#All],[Env]],SMALL(IF((C7>=tblEnv[[#All],[From Date]])*(C7<=tblEnv[[#All],[To Date]])=1,ROW(tblEnv[[#All],[Env]]),""),2)),"")


Earliest help would be highly appreciated. M counting on this forum. Thanks in advance.