Formula to find a date within a range of dates for specific rows

Hi guys, I'm really struggling to write one formula, I'll be really glad someone could help me with this one.

conditions:

For each user (B1:D1) / column in Table A, find matching rows in table B (A:A)
and
Check if date (A:A) in Table A is within a range (>=B and =<C) in Table B (for that user)

I would like to use this formula in conditional formatting to highlight cells that match this rule. Basically would like to highlight cells where particular user was away from work based on data provided in Table B.

Please see attached example.Formula help.xlsx

Thanks.