Count days per month between two dates

[ryets]

Hey,

There may already by a similar thread but I have not found it. I am currently trying to develop a formula to calculate the number of days per motnh between a range of dates. ie. Between December 30th and January 5th, how many days were in December and how many in January? So the response should be 2 and 5 respectively.

I have modified a formula I found that has almost gotten the right output but the DAYS360 does not allow for the proper output as it seems to take a day off each month. Can someone help me rework this formula o maybe create a completely different one?? Here is the formula I am currently using and a copy of the sheet.

=IF($B5="","",MAX(0,DAYS360(MAX($B5,D$3),MIN($C5,EOMONTH(D$3,0)))))

[FDibbins]

I havnt looked at your file, but assuming date1 is in A1 and date2 is in B1, in C1 use this...
=DATEDIF(A1,B1,"d")

[daddylonglegs]

You can get the number of days between 2 dates with a simple subtraction of the earlier date from the later one, try this formula in D5 copied across and down

=IF($B5="","",MAX(0,MIN($C5,D$4)-MAX($B5,D$3)+1))

[ryets]

That would work fine for just the numbers of days in between the dates in A1 and B1 but I need to know how many of those days are in January in C1, how many in February in D1, etc.

[ryets]

Thanks long legs. That seemed to be exactly what I needed!

[e.isayev]

An array formula

d5 > =SUM(--((DATE(2013,D$1,ROW($1:$31))>=$B5)+(DATE(2013,D$1,ROW($1:$31))<=$C5)=2)) CSE

added number of months to the first row as a helper column