How to Design Calendar based on schedule dates & Leave of Absence?

[#1]

Hi,

I have the following 2 calendar dates ranges.  One is the planned schedule date ranges for individual and the other is the leave date range taken by individual.  I need to know how to design this so I can have a count of number of available people in a schedule date.

I had combine these 2 dates range under one table. the dates ranges is under the columns - Duration Start, Duration End.  Highlight in yellow is the leave of absence. 

How should I design this so I can meet my objective?

Example.

Thanks

Chun Wey