Highlighting work days declared by workers

Hi everyone,

The issue I'm currently facing is not the easiest thing to explain, but I'll do my best to be as clear as possible.

The objective:
I would like to be able to track which people have worked which days, by highlighting on a calendar the days they have declared in another tab. Basically, they would type in another tab of the file when they work (in a specific format, description below) and it would automatically highlight the days of this period on the main tab, where they have a calendar associated with their name.

Description:

I would have 2 sheets on my excel file. The first one would be where the employees enter their work period. At the moment it follows this format:

Name	Start Date	End Date	Total days
Marine	01/01/2013	04/01/2013	4
Bobby	02/01/2013	03/01/2013	2
Marine	08/01/2013	10/01/2013	3

Works enter their work periods with their name in the first column.

Then, we have a second sheet with a calendar-style table:

	Monday	Tuesday	Wednesday	Thursday
January			1	2
February	1	2	3	4

(The date above are random. The table display the 12 months and every day of the month. It's just a shortened version for the forum)

We would have ONE table per employee (all on the same excel sheet) and the days that have been filled in the first table should be highlighted in the worker's table. For instance, in Marine's calendar, the dates from 01/01/2013 to 04/01/2013 and from 08/01/2013 to 10/01/2013 should be highlighted.

I hope I was clear enough in my description and request
Feel free to ask me for additional detail if necessary

Edit : added an excel file with the tables, in case my description sucked big time

This formula in CF rules does what you want, BUT, as you work to 2 differentd sheets you have also to use Named Ranges...

=SUMPRODUCT((Names=$B$2)*(MONTH(DateA)=MONTH($B3))*(DAY(DateA)<=C$3)*(DAY(DateB)>=C$3))