I have a data set that only includes the date of an admit and how many consecutive days that admit occurred for each member.  I am trying to see how many admit days occurred in each month.  For example, If a member has an admit date of 1/20/2014 and a day count of 15,  Then 12 days should be attributed to January and 3 days to February.  Then end result should be monthly bins with total number of admit days for all members in them.

No sample viz, but sample data attached.

Thanks,

Josh