Calendar Year. Change colour of date if date between (inclusive) a date interval.

I have an Excel file with two sheets. One with the full year calendar, and another with a set of records which are selected from a SQL Database table. I want the days in the calendar to change to green colour if that day exists in an inclusive interval of days which are in the second sheet. The initial date is in column D and the final date is in column E. Can someone explain me how to achieve that based on the file attached?

The file is here:
https://dl.dropboxusercontent.com/u/...C3%A9rias.xlsx

or here:
Mapa de Férias.xlsx

Many of our users are unable to view file sharing links due to firewall restriction, so it's always best to create an actual attachment.

Without seeing your document, I'll make the some assumptions:
A1 = date in sheet1
Sheet2!D1:D500 start dates
Sheet2!E1:E500 end dates

Conditional Format based on formula for A1

=SUMPRODUCT((Sheet2!$D$1:$D$500<=A1)*(Sheet2!$E$1:$E$500>=A1))>0

Copy formatting to other cells.

This calendar is beautiful.

I added the formula to B9, and then expanded the ranges to B9:H14, K9:Q14, etc for all months.

Then I went moved all month<>month formats to the stop, and checked the box "Stop if true" so that gray days don't turn green.