Excel as a calendar? Need help with date projection

[1.zer0]

I would like to use excel as a calendar for workers on jobs so it highlights when and how long free works days are. I have 2 sheets, one as the calendar and one with the jobs.

If on the calendar i select worker 1 started on job 1 on monday, using the data from the job sheet that would display job 1 is 30 days, I would like the calendar sheet to show red for 30 days.

I have attached the template of how i thought it would work for better clarification. Maybe there's and easier way?

Thanks

[1.zer0]

*bump*

anyone able to help with this?