Modify a forum formula to work across several months

[nicki_rae22]

Hello,

I recently sought out help with creating a formula to help me find the amount of days for a specific month between two dates. Here is the link: http://www.excelforum.com/excel-form...end-dates.htmlI didn't realize until just today that I would be expected to be able to modify the formula to work for every month going forward. Example, a start date of 11/25/13 and an end date of 3/15/14. I need the days between those two dates for January 2014 (31), February 2014 (28), and March 2014 (15). Does that makes any sense? Attached I have both formulas I was provided. Can anyone Help?

[bebo021999]

Try in C2:
=IF(AND(C$1>=$A2,C$1<=$B2),DAY(MIN(EOMONTH(C$1,0),$B2)),"")
Drag down and across

[nicki_rae22]

bebo021999,

Thank you! That is exactly what I need! Much appreciated!

[nicki_rae22]

bebo021999,

actually, it works great accept for when the start date is in one of the respective months. (i.e start date 1/1/14, end date 3/15/14, jan 2014 = blank (needs to be 31), feb 2014 = 28, mar 2014 = 15). Is there a way to accomodate start dates for the 2014 months? Thank you very much for your time on this!

[bebo021999]

Maybe:
=IF(AND(EOMONTH(C$1,0)>=$A2,C$1<=$B2),DAY(MIN(EOMONTH(C$1,0),$B2)),"")

[nicki_rae22]

bebo02199,

Sorry for the delay. I really appreciate your time on this. This formulas is closer to what I need, but it does not count the days correctly between dates in the same month now. (i.e. start date: 2/10/14, end date: 2/22/14, should be 12 days, but instead is showing up as 22 days). Is there a way to compensate for that as well? Or am I being too greedy? :-)

[daddylonglegs]

Try this formula in C2 copied across and down

=MAX(0,MIN(EOMONTH(C$1,0),$B2)-MAX(C$1,$A2)+1)

That will give you zero in months where there is no overlap, custom format as

0;;;

to hide zero values, see attached

[nicki_rae22]

daddylonglegs,

That does it! Thank you for your input! Both you and bebo021999 have been very helpful, and I have learned a lot from this experience!