Calculating unique days in from a series of ranges

I have a series of date ranges and I'm trying to find a solution (ideally without pivot tables) to count the unique days within the ranges by month.

For example, for the following ranges:

1/10/2012 - 1/12/2012 (3 total days, 3 unique days in Jan)
1/12/2012 - 1/15/2012 (4 total days, 3 unique days in Jan, as 1/12 was already counted)
1/30/2012 - 2/2/2012 (4 total days, 2 unique days in Jan, as 2/1 and 2/2 would fall under February)

So for January, the total I'd be looking for was 8.

Had a bunch of false starts, but can't seem to wrap my head around this one. Any suggestions to get me going?

Thanks,
Larry

I assume that your dates are in two columns.

I have used A3:B5.

In C3 try this:-

"=MIN(B3,EOMONTH(A3,0))-A3+IF(A3>B2,1,0)"

B2 should not hold text, it upsets the formula.

This should give you some ideas!

EllBol

Thanks, but this formula doesn't appear to look across the multiple ranges, just a single range.

Basically, want a file that will look like the attached. To further complicate, I'm trying for a solution that can be using for multiple individuals and would only track unique days in the month for that given individual.