Highlight cells in calendar based on date ranges in another table

Dear excel gurus, please, help me.

I have a table in which each employee has one row, and in it is a calendar with many columns starting from year 2013 till today.
In another table I have multiple rows for each employee with date ranges when they were not working.
I need to highlight in red cells in the calendar for each employee, when he was not working.

Thank you very much.