INDEX/MATCH with greater than or less than criteria

I have included the data I am working with but essentially what I am trying to do is for INDEX/MATCH to look at one column and determine where todays date is greater than one column (C in my example) and less than another column (D in my example) and return the corresponding value in the other column (B in my example).

HTML Code: 

I was trying this function but not having any luck

{=IFERROR(INDEX($A$2:$A$8,MATCH(1,($B$2:$B$8>=$B$10)*($C$2:$C$8<=$B$10),0)),"-")}

I removed all Sundays in this for a reason however if I need to reorganize my data in one column, it wouldn't be the end of the world. Thanks in advance!

Apologies, I had extra data in column A and removed it but forgot to adjust the formula, however in the data in the post I changed it.

And in response to your answer, are you saying if I combine the data (i.e. just remove column C) and make the formula just a greater than equal to, that would work? I tried playing with that with no luck.

hi there,
did you manage the formula? I do have a same issue at the moment