I'm trying to calculate how many days fall into each month from a date range.

As example: Date Range: Jan 15, 2013 - April 3, 2013

I need formula that calculates the total days and fills in how many days per month as shown below:


15-Jan-13 3-Apr-13

jan feb mar apr may june july aug sept oct nov dec
16 28 31 3 0 0 0 0 0 0 0 0

Can you help me? Thanks!!