how to convert calendars into a chart??

Instead of paying hundreds of dollars for some child custody program, i figured I'd try to make my own excel templates. This might not be possible, but who knows!

I am having trouble of how to convert calendar usage into a chart.

For instance... I made a calendar for February; i would fill a block PINK for 1st, 2nd, and 3rd to display that mother has the kids those days. And fill other blocks into blue for 4th, 5th, 6th for father.

What i am trying to do here is to make a visual pie chart to show how many days mother/father had so far along with the blocks that were already filled with pink/blue colors.

Hopefully someone can understand what i'm trying to do here! Thanks!